SQL 判断表是否存在
时间:2022-03-14 16:23
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;