Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF OBJECT_ID('temp_ARCHIVE_RECORD_COUNTS') IS NOT NULL
- DROP TABLE temp_ARCHIVE_RECORD_COUNTS
- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[TableName]') AND type in (N'U'))
- DROP TABLE TableName;
- GO
- if exists (select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME='MyTable') begin
- drop table MyTable
- end
- IF EXISTS( SELECT * FROM dbo.sysobjects where id = object_id(N'TABLENAME') AND OBJECTPROPERTY(id, N'IsTable') = 1)
- BEGIN
- DROP TABLE TABLENAME
- END
Add Comment
Please, Sign In to add comment