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 vote120 views1 answer
What are the aggregate function in sql
SQL
0 vote139 views1 answer
Original Query
SQL
0 vote114 views1 answer
Database springboot
SQL
1 vote94 views1 answer
Convert money to varchar sql server
SQL
1 vote126 views1 answer
Psql filed name alter
SQL
8 votes131 views1 answer
Oracle create datafile
SQL
3 votes134 views1 answer
Sql server check version
SQL
2 votes128 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote127 views1 answer
Mariadb datetime change to microseconds
SQL
6 votes124 views4 answers
Sqlite drop table
SQL