Can i use Default in Alter Statements

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  April 20, 2010 at 12:42 am

  #217985

  hi,

  I am having a table. which is taking by default NULL values...

  Now i want to update the Column default to'XXXX'

  Script:-

  CREATE TABLE [dbo].[Testowners](

  [owner_id] [int] NULL,

  [owname] [varchar](15) NULL

  )

  Alter Script 1:-

  ALTER TABLE Owners

  ALTER Column [owner_id] INT NOT NULL

  Alter Script 2:-

  ALTER TABLE Owners

  ALTER Column owname VARCHAR(35) Default 'XX'

  The first Alter Statement is working fine.

  Cant i use the Default in Alter statement ....

  Thnaks in advance.......

• 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

• Paul White

  SSC Guru

  Points: 150467

  More actions

  April 20, 2010 at 5:43 am

  #1154469

  That is the Books Online entry for SQL Server Compact 3.5 Service Pack 1.

  You want the SQL Server 2008 entry:

  http://msdn.microsoft.com/en-us/library/ms190273.aspx

  Paul White
  SQLPerformance.com
  SQLkiwi blog
  @SQL_Kiwi