如果表存在SQL，则删除行

要签入SQL SERVER，

IF (EXISTS (SELECt * FROM INFORMATION_SCHEMA.TABLES WHERe TABLE_SCHEMA = 'TheSchema' AND  TABLE_NAME = 'TheTable'))BEGIN    --Do StuffEND

要检查mysql：

您只需数：

SELECt COUNT(*)FROM information_schema.tables WHERe table_schema = '[database name]' AND table_name = '[table name]';