Home Forums SQL Server 2008 T-SQL (SS2K8) Can i use Default in Alter Statements RE: Can i use Default in Alter Statements
Pulivarthi Sasidhar
SSCertifiable
Points: 6706
More actions
April 20, 2010 at 12:54 am
#1154348
I got solution......... :-D:-D
ALTER Table Owners
ADD CONSTRAINT con_owname DEFAULT 'XXX' FOR owname
But Y dont we use Default in the Alter statement. Event the below link shows it in Syntax...by SET Default...
http://msdn.microsoft.com/en-us/library/ms174123.aspx