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 vote367 views1 answer
Cube oracle
SQL
0 vote369 views1 answer
Postgres list tables and row counts
SQL
0 vote361 views1 answer
Pgadmin check database
SQL
0 vote315 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote341 views1 answer
Drop-toys-table
SQL
4 votes1.1K views1 answer
Oracle show errors
SQL
0 vote329 views1 answer
Case when with count and combining similar values in sql
SQL
12 votes329 views1 answer
Psql drop column
SQL
0 vote334 views1 answer
Mysql type for large numbers with many decimal
SQL
0 vote354 views1 answer
Postgre query date
SQL