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

0 vote223 views1 answer
Oracle date summer time
SQL
0 vote187 views1 answer
Sql server split string and insert into table select
SQL
2 votes195 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
-1 vote185 views1 answer
Mysql case when multiple conditions
SQL
0 vote223 views1 answer
Finding leap year in sql
SQL
1 vote322 views1 answer
Primary key reset in SQL database
SQL
0 vote194 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
15 votes194 views3 answers
Find duplicate keys in mysql
SQL
1 vote192 views1 answer
Postgres grant read only access to database
SQL
17 votes219 views3 answers
Postgresql list users
SQL