SQL 判断表是否存在

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Users_TEMP') AND type in (N'U'))
    BEGIN
        DROP TABLE Users_TEMP;
        SELECT * INTO Users_TEMP FROM Users WHERE 1=2;
    END
ELSE
    BEGIN
        SELECT * INTO Users_TEMP FROM Users WHERE 1=2;
    END;

 

posted @ 2015-11-20 15:19  如.若  阅读(319)  评论(0)    收藏  举报