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

50 votes345 views6 answers
Sql duplicate rows
SQL
12 votes275 views2 answers
Delete all entries postgres
SQL
0 vote265 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote281 views1 answer
Mssql + bit + in python orm
SQL
1 vote281 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote293 views1 answer
Compare field sql server
SQL
8 votes284 views10 answers
Sql
SQL
2 votes262 views1 answer
Sql ignore accents
SQL
8 votes275 views2 answers
Safe update mode in mysql
SQL
10 votes265 views4 answers
Fetch first 5 characters of the string in sql
SQL