CREATE TABLE [Table1] (
	[id] [int] IDENTITY (1, 1) NOT NULL ,
	[Name] [varchar] (50) NOT NULL
)

DROP TABLE dbo.Table1

ALTER TABLE [Table] ADD [Column] Column_type not null [default 0]
GO

BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
CREATE TABLE dbo.Tmp_Table1
	(
	id int NOT NULL IDENTITY (1, 1),
	qwe char(10) NULL,
	qqq int NULL,
	Name varchar(50) NOT NULL
	)  ON [PRIMARY]
GO
SET IDENTITY_INSERT dbo.Tmp_Table1 ON
GO
IF EXISTS(SELECT * FROM dbo.Table1)
	 EXEC('INSERT INTO dbo.Tmp_Table1 (id, qqq, Name)
		SELECT id, qqq, Name FROM dbo.Table1 (HOLDLOCK TABLOCKX)')
GO
SET IDENTITY_INSERT dbo.Tmp_Table1 OFF
GO
DROP TABLE dbo.Table1
GO
EXECUTE sp_rename N'dbo.Tmp_Table1', N'Table1', 'OBJECT'
GO
COMMIT