第一种:
-------------------------------------------------------------------
第二种:
SHOW CREATE TABLE 'tableName';
SELECT CONSTRAINT_CATALOG,
CONSTRAINT_SCHEMA,
CONSTRAINT_NAME,
TABLE_SCHEMA,
TABLE_NAME,
CONSTRAINT_TYPE
FROM
information_schema.TABLE_CONSTRAINTS
WHERE
TABLE_NAME='tableName'
-------------------------------------------------------------------
第二种:
SHOW CREATE TABLE 'tableName';