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

2 votes229 views1 answer
Q operator in sql
SQL
10 votes223 views5 answers
Between keyword in sql
SQL
0 vote237 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
12 votes237 views2 answers
Update column data type postgres
SQL
0 vote239 views1 answer
Create function in microsoft sql server
SQL
4 votes245 views2 answers
Oracle unlock account
SQL
0 vote213 views1 answer
Oracle list dblink
SQL
13 votes221 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
2 votes243 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote309 views1 answer
Create view in sql server that contain multiple select statements
SQL