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 vote202 views1 answer
Query by column for substring sql
SQL
13 votes284 views2 answers
Sqlite rename table
SQL
0 vote249 views1 answer
Capabilities of sql select statements
SQL
1 vote206 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
4 votes283 views2 answers
Mysql alter table set column unique
SQL
0 vote203 views1 answer
Oracle synonym procedure dblink
SQL
3 votes197 views1 answer
Get current month last date in sql server
SQL
0 vote189 views1 answer
Concatenate columns in table
SQL
0 vote190 views4 answers
First max salary in sql
SQL
1 vote179 views4 answers
Sql now
SQL