SELECT C.TABLE_NAME,COLUMN_KEY AS CONSTRAINT_TYPE,COLUMN_KEY AS CONSTRAINT_NAME,C.COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS C WHERE 1=1
mysql查询表名 列名 列类型等
最新推荐文章于 2024-03-16 15:51:32 发布
SELECT C.TABLE_NAME,COLUMN_KEY AS CONSTRAINT_TYPE,COLUMN_KEY AS CONSTRAINT_NAME,C.COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS C WHERE 1=1