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 vote199 views1 answer
Define a variable in mysql from select
SQL
0 vote176 views1 answer
Psql select * from table
SQL
0 vote199 views1 answer
Microsoft word insert sql code
SQL
3 votes181 views1 answer
Oracle APEX elapsed time
SQL
0 vote241 views1 answer
Select count concat string sql server
SQL
-1 vote206 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
9 votes181 views2 answers
Get first 3 letters in sql
SQL
1 vote182 views1 answer
Oracle db create new schema
SQL
40 votes263 views4 answers
PostgreSQL add column
SQL
7 votes216 views1 answer
Mysql unsafe update
SQL