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 vote238 views1 answer
Mysql query problems and solutions
SQL
1 vote259 views1 answer
Get current date in pyspark sql
SQL
0 vote243 views1 answer
Microsoft sql server python connection
SQL
0 vote344 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
4 votes244 views1 answer
Conda install sqlalchemy
SQL
2 votes224 views3 answers
Postgres remove foreign key constraint
SQL
8 votes235 views1 answer
Oracle all_source package body
SQL
1 vote224 views1 answer
Stop mysql server mac
SQL
5 votes230 views1 answer
Oracle scan source ddl
SQL
0 vote245 views2 answers
Reseed sql identity
SQL