Sql记录：判断表或字段是否存在

COUNT(*) AS ct FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = ‘表名‘;

 

判断字段是否存在：

SELECT COUNT(*) AS ct FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = ‘表名‘ AND COLUMN_NAME = ‘字段名‘;

 

Sql记录：判断表或字段是否存在

标签：数据类型   文件   count   存在   详细   and   而不是   table   from