MySql get primary keys of table

SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'Your Database'
  AND TABLE_NAME = 'Your Table name'
  AND COLUMN_KEY = 'PRI';


SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'Your Database'
  AND TABLE_NAME = 'Your Table name'
  AND COLUMN_KEY = 'UNI';

Source: stackoverflow.com

Similar codes

5 votes174 views2 answers
Copy data from one database to another
SQL
0 vote209 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
1 vote176 views1 answer
Postgres select as csv
SQL
0 vote201 views1 answer
Sql tabelle erstellen
SQL
0 vote181 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
0 vote175 views1 answer
Oracle grant create job
SQL
0 vote154 views1 answer
How to fetch highest score in minimum time using mysql
SQL
9 votes185 views4 answers
Oracle get table column names
SQL
14 votes259 views1 answer
How to export db from mysql
SQL
0 vote177 views1 answer
Resulting Query
SQL