如果表存在SQL，则删除行 [英] Delete row if table exists SQL

问题描述

我有一个脚本，该脚本可以使用DROP TABLE IF EXISTS删除表的负载，

I have a script that drops a load of tables using DROP TABLE IF EXISTS, this works.

此脚本中还有一个删除操作，用于从我不管理的另一个表中删除一行.该表可能存在或不存在.是否有任何在尝试删除行之前检查该表是否存在?

There is also a delete in this script to DELETE a row from another table that I do not manage. This table may or may not exist.Is there any to check the table exists before attempting to delete a row?

这需要适用于MYSQL和SQLServer

this needs to work for MYSQL and SQLServer

谢谢 亚历克斯

推荐答案

要检入SQL SERVER，

To check in SQL SERVER,

IF (EXISTS (SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'TheSchema' AND  TABLE_NAME = 'TheTable'))
BEGIN
    --Do Stuff
END

要检查mysql，

您只需数:

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

这篇关于如果表存在SQL，则删除行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！