USE LL GO SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME IN ( SELECT TABLE_NAME from INFORMATION_SCHEMA.TABLES ) AND COLUMN_NAME ='' TABLE_NAME 指表名 COLUMN_NAME 指字段名
USE LL GO SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME IN ( SELECT TABLE_NAME from INFORMATION_SCHEMA.TABLES ) AND COLUMN_NAME ='' TABLE_NAME 指表名 COLUMN_NAME 指字段名