/ Published in: SQL
Expand |
Embed | Plain Text
ALTER TABLE [DBName].[dbo].[TableName] ADD ColumnName int NOT NULL DEFAULT(DefaultValuefortheColumn) GO
You need to login to post a comment.
certainlyakey on 07/22/10
1 person have marked this snippet as a favorite
ALTER TABLE [DBName].[dbo].[TableName] ADD ColumnName int NOT NULL DEFAULT(DefaultValuefortheColumn) GO
You need to login to post a comment.