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 vote330 views2 answers
Default constraint in ms sql
SQL
0 vote317 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote294 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote328 views1 answer
How to select multiple columns from different tables in mysql
SQL
3 votes321 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote353 views1 answer
Yesql
SQL
0 vote346 views1 answer
Sqlite unique multiple columns
SQL
0 vote320 views3 answers
Sql server import json
SQL
57 votes545 views6 answers
Mysql alter table add column
SQL
0 vote338 views1 answer
Sql server for loop
SQL