BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_tabletest
(
id int NOT NULL IDENTITY (1, 1)
) ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_tabletest ON
GO
IF EXISTS(SELECT * FROM dbo.tabletest)
EXEC('INSERT INTO dbo.Tmp_tabletest (id)
SELECT id FROM dbo.tabletest TABLOCKX')
GO
SET IDENTITY_INSERT dbo.Tmp_tabletest OFF
GO
DROP TABLE dbo.tabletest
GO
EXECUTE sp_rename N'dbo.Tmp_tabletest', N'tabletest', 'OBJECT'
GO
COMMIT