“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 ·
907 阅读 ·
0 评论