ALTER table syntax

ALTER TABLE [dbo].[PendingTravel]

     ALTER COLUMN 
[createdate] [datetime] NULL CONSTRAINT [DF_PendingTravel_createdate] DEFAULT (getdate()),

--##############################################

ALTER TABLE [dbo].[tblEvaluationComments]

     ALTER COLUMN CommentText varchar(2000) NULL;

ALTER TABLE dbo.tblEvaluationOverview

     ADD

     [EffDateTEST] [datetime] NULL

ALTER TABLE dbo.tblEvaluationOverview

     DROP COLUMN [EffDateTEST]

--##########################################

USE [Evaluation]

GO

/****** Object:  Table [dbo].[tblRoles]    Script Date: 03/23/2010 13:46:59 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

ALTER TABLE [dbo].[tblMetrics]

     ADD

     [CategoryID] [int] NULL ,

       [ContractID] [int] NULL ,

       [SDSTypeID] [int] NULL    

GO

SET ANSI_PADDING OFF

ALTER TABLE [dbo].[tblMetrics]  WITH CHECK ADD  CONSTRAINT [FK_tblMetrics_tblCategories] FOREIGN KEY([CategoryID])

REFERENCES [dbo].[tblCategories] ([CategoryID])

GO

ALTER TABLE [dbo].[tblMetrics]  WITH CHECK ADD  CONSTRAINT [FK_tblMetrics_tblContracts] FOREIGN KEY([ContractID])

REFERENCES [dbo].[tblContracts] ([ContractID])

GO

ALTER TABLE [dbo].[tblMetrics]  WITH CHECK ADD  CONSTRAINT [FK_tblMetrics_tblContracts] FOREIGN KEY([ContractID])

REFERENCES [dbo].[tblContracts] ([ContractID])

GO

--#######################################################

USE [Evaluation]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tblSDSType](

       [SDSTypeID] [int] NOT NULL,

       [DSDTypeName] [varchar(20)] NOT NULL    

) ON [PRIMARY]

GO

ALTER TABLE [dbo].[tblTaskBudget]  WITH CHECK ADD  CONSTRAINT [FK_tblTaskBudget_tblTasks] FOREIGN KEY([TaskID])

REFERENCES [dbo].[tblTasks] ([TaskID])

GO