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 vote380 views1 answer
Creating sqeuence in oracle database
SQL
0 vote355 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote363 views2 answers
Mysql create table if not exists
SQL
1 vote347 views1 answer
Postgres first_value in gropby
SQL
1 vote348 views2 answers
Select only columns that are not empty oracle sql
SQL
1 vote323 views1 answer
Update from select join
SQL
3 votes392 views1 answer
What is having
SQL
0 vote348 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote374 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote296 views0 answer
How to connect to datbase in springboot
SQL