Physical Address

304 North Cardinal St.
Dorchester Center, MA 02124

Category MySQL

Check MySQL / MariaDB table for Primary Key

check mysql / mariadb table for primary key

It is pretty straightforward to check a MySQL / MariaDB table for a Primary Key, connect to the db server, login or open up your favorite MySQL client. Without selecting any table, issue the following command: SHOW INDEXES FROM <TABLE>…