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 vote211 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
10 votes218 views3 answers
Join multiple tables sql
SQL
0 vote215 views2 answers
Postgresql get last day of month
SQL
0 vote211 views1 answer
Oracle date summer time
SQL
44 votes230 views6 answers
Rename command in sql
SQL
0 vote232 views1 answer
Store case result sql
SQL
0 vote233 views1 answer
Mysql a from on this page has
SQL
0 vote215 views1 answer
Creation d'un trigger sql
SQL
1 vote220 views1 answer
Oracle sql listagg
SQL
1 vote229 views1 answer
How to fetch alternate records from two tables
SQL