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 vote355 views1 answer
Check if database exists sql
SQL
0 vote347 views1 answer
How to check which sp is running in sql server
SQL
0 vote404 views1 answer
Combine 2 columns search query mysql
SQL
0 vote434 views1 answer
Add two days to current date in sql when creating tables
SQL
0 vote344 views1 answer
Postgres select except
SQL
0 vote373 views2 answers
Add colum in sql
SQL
1 vote358 views2 answers
Mysql: command not found
SQL
21 votes405 views6 answers
Update sql
SQL
16 votes385 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote438 views1 answer
Why do we need data structure in sql
SQL