Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-04 : 09:47:12
|
| Akon writes "I have bit data type column and want to set it's default value to 1I am using query below but gettting syntax error does any one know what's worng with this query table name is dbo.Dim_Usage_Type and column name is checked. Alter table dbo.Dim_Usage_Type Alter column checked SET DEFAULT 1 thanks" |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-01-04 : 10:45:29
|
| ALTER TABLE dbo.Dim_Usage_Type ADD DEFAULT 1 FOR checked |
 |
|
|
|
|
|
set default on Bit Datatype column