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

3 votes223 views2 answers
Enter mysql command line
SQL
18 votes174 views3 answers
Find column name in database
SQL
0 vote226 views2 answers
Uninstall postgresql mac
SQL
0 vote165 views1 answer
Replace multiple string in query sql
SQL
13 votes184 views1 answer
Select count of distinct values sql
SQL
12 votes291 views2 answers
Find duplicates mysql column
SQL
8 votes163 views1 answer
How to remove tables from postgresql
SQL
0 vote258 views1 answer
Shortcut run sql pgadmin
SQL
0 vote171 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote182 views1 answer
Primary key multiple
SQL