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 vote341 views1 answer
How to save data in database in mysql node
SQL
0 vote353 views1 answer
Postgresql combine values in one field
SQL
0 vote373 views1 answer
How to join result table in mysql
SQL
0 vote336 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote381 views1 answer
Oracle list datafiles
SQL
0 vote338 views1 answer
Storing RGBA in mysql db
SQL
0 vote378 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL
3 votes363 views1 answer
Oracle failed login attempts
SQL
0 vote376 views1 answer
Split string by comma in sql server
SQL
1 vote351 views1 answer
Join to find results not in another table
SQL