Disclaimer: This article may contain information about third-party products. Such information is for reference only. Alibaba Cloud does not make any guarantee, express or implied, with respect to the performance and reliability of third-party products, as well as potential impacts of operations on the products.
This topic describes how to view the primary key fields of a table in apsaradb for MySQL.
When using a MySQL instance, the following three methods are commonly used to view primary key fields. Select a method as needed.
View system tables
Run the following SQL statement to confirm the primary key fields in the system table.
SELECT t.TABLE_NAME, t.CONSTRAINT_TYPE, c.COLUMN_NAME, c.ORDINAL_POSITION FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS t, INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS c WHERE t.TABLE_NAME = c.TABLE_NAME AND t.CONSTRAINT_TYPE = 'PRIMARY KEY' AND t.TABLE_NAME='[$Table_Name]' AND t.TABLE_SCHEMA='[$DB_Name]';
- [$Table_Name] is the table name.
- [$DB_Name] is the name of the database where the table is located.
View the CREATE TABLE statement
Run the following SQL statement to confirm the primary key fields through the table creation statement.
show create table [$Table_Name];
View Table Structure
Run the following SQL statement to confirm the primary key field based on the table structure.
- Apsaradb for MySQL