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 vote197 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote194 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
1 vote208 views2 answers
How to check if sql query is correct online
SQL
1 vote200 views2 answers
Sql where keyword
SQL
0 vote216 views1 answer
Mysql subtract month from timestamp
SQL
11 votes196 views4 answers
Query DISTINCT
SQL
1 vote207 views2 answers
Sql multiline comment
SQL
0 vote191 views1 answer
Sql random decimal
SQL
0 vote200 views1 answer
How get data from database if id not found then search another column
SQL
9 votes189 views3 answers
Mysql get last id
SQL