--REMOVE THE DEFAULT CONSTRAINT FROM COLUMN__NAME COLUMN IN TABLE__NAME
DECLARE @TableName varchar(512),@ColumnName varchar(512),@DefaultName varchar(512)
SET @TableName='TABLE__NAME'
SET @ColumnName='COLUMN__NAME'
SELECT @DefaultName=df.[name] from syscolumns as sc
	INNER JOIN sysobjects as so on so.ID = sc.ID
	INNER JOIN sysobjects as df on so.ID = df.parent_obj
		   AND sc.cdefault = df.ID
	WHERE ( (so.[name]=@TableName)  AND
			(sc.[name]=@ColumnName) AND
			(df.xtype='D') )
IF (@DefaultName is not NULL)
	BEGIN
		EXECUTE('ALTER TABLE ' + @TableName + ' DROP CONSTRAINT ' + @DefaultName)
		print    '--> table: ' + @TableName + ' constraint dropped'
	END
ELSE
	print '--> table: ' + @TableName + ' is up to date'
GO


-- DROP FOREIGN KEY CONSTRAINT__NAME FROM TABLE__NAME
IF EXISTS (
    SELECT * FROM sys.foreign_keys
	 WHERE object_id = OBJECT_ID(N'[dbo].[CONSTRAINT__NAME]')
	    AND parent_object_id = OBJECT_ID(N'[dbo].[TABLE__NAME]') )
	BEGIN
		ALTER TABLE [TABLE__NAME]
		DROP CONSTRAINT CONSTRAINT__NAME
		print '--> table: [TABLE__NAME] CONSTRAINT__NAME constraint dropped'
	END
ELSE
	print '--> table: [TABLE__NAME] CONSTRAINT__NAME is up to date'
GO

-- DROP CONSTRAINT__NAME FROM TABLE__NAME
IF EXISTS
	(SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
	 WHERE CONSTRAINT_SCHEMA='dbo'
			AND CONSTRAINT_NAME='CONSTRAINT__NAME'
			AND TABLE_NAME='TABLE__NAME')
	BEGIN
		ALTER TABLE TABLE__NAME
		DROP CONSTRAINT CONSTRAINT__NAME
		print '--> table: TABLE__NAME CONSTRAINT__NAME constraint dropped'
	END
ELSE
	print '--> table: TABLE__NAME CONSTRAINT__NAME is up to date'
GO

--DROP COLUMN__NAME COLUMN FROM TABLE__NAME
IF EXISTS (
	SELECT sc.[name] FROM syscolumns AS sc
	INNER JOIN sysobjects AS so ON so.ID = sc.ID
	WHERE so.[name] = 'TABLE__NAME'
			AND sc.[name] = 'COLUMN__NAME' )
	BEGIN
		ALTER TABLE TABLE__NAME
		DROP COLUMN COLUMN__NAME
		print '--> table TABLE__NAME updated'
	END
ELSE
	print '--> table TABLE__NAME up to date'
GO

-- ADD FOREIGN KEY CONSTRAINT__NAME CONSTRAINT
IF NOT EXISTS
	(SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
	 WHERE CONSTRAINT_SCHEMA='dbo'
			AND CONSTRAINT_NAME='CONSTRAINT__NAME'
			AND TABLE_NAME='TABLE__NAME')
	BEGIN
		ALTER TABLE
			[TABLE__NAME]
		ADD CONSTRAINT
			[CONSTRAINT__NAME]
		FOREIGN KEY
			([COLUMN__NAME__ID])
		REFERENCES
			[SLAVE__TABLE] ([Id])
		ON UPDATE  NO ACTION
		ON DELETE  NO ACTION
	END
GO
print '--> table: TABLE__NAME'
GO

-- ADD CHECK CONSTRAINT CONSTRAINT__NAME TO TABLE__NAME
IF NOT EXISTS
	(SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
	 WHERE CONSTRAINT_SCHEMA='dbo'
			AND CONSTRAINT_NAME='CONSTRAINT__NAME'
			AND TABLE_NAME='TABLE__NAME')
	BEGIN
		ALTER TABLE dbo.TABLE__NAME
		ADD CONSTRAINT
			CONSTRAINT__NAME
		CHECK
			([COLUMN__NAME] is NULL OR [COLUMN__NAME] >= 0)
		print '--> table: TABLE__NAME CONSTRAINT__NAME constraint added'
	END
ELSE
	print '--> table: TABLE__NAME CONSTRAINT__NAME is up to date'
GO


-- ALTER DF CONSTRAINT FOR COL__NAME IN TABLE__NAME
IF EXISTS
	(SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
	 WHERE CONSTRAINT_SCHEMA='dbo'
			AND CONSTRAINT_NAME='CONSTRAINT__NAME'
			AND TABLE_NAME='TABLE__NAME')
	BEGIN
		ALTER TABLE TABLE__NAME
		DROP CONSTRAINT CONSTRAINT__NAME
		print '--> table: TABLE__NAME CONSTRAINT__NAME constraint dropped'
	END
ELSE
	print '--> table: TABLE__NAME CONSTRAINT__NAME is up to date'
GO
IF NOT EXISTS
	(SELECT * FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
	 WHERE CONSTRAINT_SCHEMA='dbo'
			AND CONSTRAINT_NAME='CONSTRAINT__NAME'
			AND TABLE_NAME='TABLE__NAME')
	BEGIN
		ALTER TABLE dbo.TABLE__NAME
		ADD CONSTRAINT DF_TABLE__NAME_COL__NAME DEFAULT 1 FOR COL__NAME
		print '--> table: TABLE__NAME_COL__NAME constraint added'
	END
ELSE
	print '--> table: TABLE__NAME is up to date'
GO


--ALTER COLUMN__NAME COLUMN IN TABLE__NAME
IF EXISTS (
	SELECT sc.[name] FROM syscolumns AS sc
	INNER JOIN sysobjects AS so ON so.ID = sc.ID
	WHERE so.[name] = 'TABLE__NAME'
			AND sc.[name] = 'COLUMN__NAME' )
	BEGIN
		ALTER TABLE TABLE__NAME
		ALTER COLUMN COLUMN__NAME int null
		print '--> table: TABLE__NAME altered'
	END
ELSE
	print '--> table: TABLE__NAME is up to date'
GO

--ADD COLUMN__NAME COLUMN TO TABLE__NAME
IF NOT EXISTS (
	SELECT sc.[name] FROM syscolumns AS sc
	INNER JOIN sysobjects AS so ON so.ID = sc.ID
	WHERE so.[name] = 'TABLE__NAME'
			AND sc.[name] = 'COLUMN__NAME' )
	BEGIN
		ALTER TABLE TABLE__NAME
		ADD COLUMN__NAME varchar(255) NOT null DF_TABLE__NAME_COLUMN__NAME DEFAULT('')
		print '--> table: TABLE__NAME updated'
	END
ELSE
	print '--> table: TABLE__NAME up to date'
GO

--UPDATE COLUMN__NAME VALUE IN TABLE__NAME
IF NOT EXISTS (
	SELECT sc.[name] FROM syscolumns AS sc
	INNER JOIN sysobjects AS so ON so.ID = sc.ID
	WHERE so.[name] = 'TABLE__NAME'
			AND sc.[name] = 'COLUMN__NAME' )
	BEGIN
		UPDATE TABLE__NAME
		SET    COLUMN__NAME = NEW__VALUE
		WHERE THROW__ERROR__MUSTBEADDEDTO
		print '--> column COLUMN__NAME values updated'
	END
GO

-- CREATE TABLE
IF EXISTS (
	SELECT * FROM sysobjects
	WHERE id = OBJECT_ID(N'dbo.[TABLE__NAME]')
			AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
	DROP TABLE dbo.[TABLE__NAME]
	print '--> table: TABLE__NAME dropped'
GO
CREATE TABLE dbo.[TABLE__NAME] (
	[Id] 				int identity(1,1) 	NOT NULL,
	[GUID]				uniqueidentifier	NOT NULL	CONSTRAINT DF_TABLE__NAME_GUID			DEFAULT(NEWID()),
	[ModifierId]		int					NULL,
	[DateCreated]		datetime			NOT NULL	CONSTRAINT DF_TABLE__NAME_DateCreated	DEFAULT(GETDATE()),
	[DateModified]		datetime			NOT NULL	CONSTRAINT DF_TABLE__NAME_DateModified	DEFAULT(GETDATE())
	CONSTRAINT PK_TABLE__NAME PRIMARY KEY CLUSTERED (
		[Id]
	)
)
GO
print '--> table: TABLE__NAME created'
GO

exec wctConfig_HelpCreateWithValue 'MODULE__NAME','PAGE__IDENTIFIER','SECTION__HEADER','DESCRIPTION',99,'TITLE'
GO

--ADD COLUMN__NAME COLUMN TO TABLE__NAME
IF NOT EXISTS (
	SELECT sc.[name] FROM syscolumns AS sc
	INNER JOIN sysobjects AS so ON so.ID = sc.ID
	WHERE so.[name] = 'TABLE__NAME'
			AND sc.[name] = 'COLUMN__NAME' )
	BEGIN
		ALTER TABLE TABLE__NAME
		ADD COLUMN__NAME varchar(255) NOT null DF_TABLE__NAME_COLUMN__NAME DEFAULT('')
		print '--> table: TABLE__NAME updated'
	END
ELSE
	print '--> table: TABLE__NAME up to date'
GO


-- UPDATE/MOD PROC__NAME STORED PROC
IF EXISTS (
	SELECT * FROM sysobjects
	WHERE id = OBJECT_ID(N'[PROC__NAME]')
		AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
	BEGIN
		DROP PROCEDURE [dbo].PROC__NAME
		print '--> proc: PROC__NAME dropped'
	END
GO
CREATE PROCEDURE [dbo].[PROC__NAME]
	@GUID uniqueidentifier
AS
	BEGIN
		declare @err int
		set @err = 0

		SELECT top 1 *
		FROM SKY
		WHERE ABOVE

		set @err = @@ERROR
		return @err
	END
GO
print '--> proc: PROC__NAME created'
GO

--Cursor for TABLE__NAME @COLUMN__NAME
DECLARE @COLUMN__NAME int
DECLARE @message varchar(25)
DECLARE TABLE__NAME_cursor CURSOR FOR
    SELECT CT.ID
    FROM TABLE__NAME AS CT

OPEN TABLE__NAME_cursor;

FETCH NEXT FROM TABLE__NAME_cursor INTO @COLUMN__NAME;

	WHILE @@FETCH_STATUS = 0
	BEGIN
        --SELECT * FROM TABLE__NAME WHERE id = @COLUMN__NAME
		SELECT @message = ' ' + @COLUMN__NAME
		PRINT 'COLUMN__NAME: ' + @message

    FETCH NEXT FROM TABLE__NAME_cursor INTO @COLUMN__NAME;
	END;

CLOSE TABLE__NAME_cursor;
DEALLOCATE TABLE__NAME_cursor;