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

1 vote125 views2 answers
Sql server backup table
SQL
0 vote89 views0 answer
SQL
0 vote159 views1 answer
Mariadb used space
SQL
2 votes128 views1 answer
Date_format for time sql
SQL
1 vote91 views1 answer
Ms sql how to see active job current run time
SQL
2 votes140 views3 answers
Copy data from one table column to another table column in sql
SQL
11 votes206 views1 answer
Oracle insert from select
SQL
0 vote128 views1 answer
Raiserror nowait sql server
SQL
1 vote154 views1 answer
Sql list all procedures
SQL
0 vote144 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL