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

1 vote248 views1 answer
Search for tables with name postgresql
SQL
8 votes259 views1 answer
Unique vs primary key
SQL
0 vote254 views1 answer
List column names of multiple tables psql
SQL
0 vote291 views1 answer
For select oracle
SQL
31 votes260 views3 answers
SQL Server change column data type
SQL
2 votes262 views1 answer
Postgresql left join distinct on
SQL
2 votes271 views1 answer
Db.relationship sqlalchemy flask
SQL
0 vote266 views1 answer
Hotw to alter lengh character vayng postgres
SQL
1 vote269 views1 answer
Sqlalchemy order by descending
SQL
21 votes255 views4 answers
Oracle add column
SQL