Hi, You can not set
Default Value for column in
Create Script
. First
Create Table
and then using
Alter Script
you can set default value or bindings for specific column as you require. Please check this example:
DECLARE @TimeZone VARCHAR(50);
EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Control\TimeZoneInformation','TimeZoneKeyName',@TimeZone OUT;
Select 'Create Table [dbo].[Test] (
[Id] [int] IDENTITY(1,1) NOT NULL,
[Column1] [varchar] (50) NOT NULL,
[Column2] [varchar] (50) NOT NULL)
GO
ALTER TABLE [dbo].[Test] ADD CONSTRAINT [DF_SomeName] DEFAULT (N'''+@TimeZone+''') FOR [Column2]
GO'
It will create following script :
Create Table [dbo].[Test] (
[Id] [int] IDENTITY(1,1) NOT NULL,
[Column1] [varchar] (50) NOT NULL,
[Column2] [varchar] (50) NOT NULL)
GO
ALTER TABLE [dbo].[Test] ADD CONSTRAINT [DF_SomeName] DEFAULT (N'India Standard Time') FOR [Column2]
GO
I hope this will help you. :)