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

3 votes141 views1 answer
Oracle wait
SQL
10 votes131 views1 answer
Oracle dependency
SQL
0 vote186 views1 answer
Sqlite trim
SQL
0 vote161 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
0 vote167 views1 answer
Hierarchal database table
SQL
5 votes170 views2 answers
Oracle list columns
SQL
0 vote184 views1 answer
Add computed column to table sql server
SQL
0 vote145 views1 answer
Sql sum if
SQL
0 vote154 views1 answer
Postgresql check total storage
SQL
1 vote142 views2 answers
String to date postgres
SQL