“DROP TABLE IF EXISTS” in Oracle and SQL Server
MySQL:DROP TABLE IF EXISTS [table_name]Oracle:BEGIN EXECUTE IMMEDIATE 'DROP TABLE [table_name]'; EXCEPTION WHEN OTHERS THEN NULL;END;SQL Server:IF EXISTS ( SELECT TABLE_NAME FROM INFORMATIO...
原创
2013-08-26 22:45:23 ·
864 阅读 ·
0 评论