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 vote139 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote129 views1 answer
SQLServerException.makeFromDatabaseError
SQL
1 vote110 views1 answer
PLS-00225 type
SQL
9 votes113 views4 answers
How to remove duplicate in sql
SQL
1 vote109 views1 answer
Drush sql-dump
SQL
1 vote117 views3 answers
Mysql connection string
SQL
0 vote146 views1 answer
Many rows to 1 string mysql
SQL
0 vote111 views1 answer
Sql server manager close connection
SQL
0 vote111 views1 answer
Remove from table where
SQL
1 vote113 views1 answer
Data type and their numeric form
SQL