How we set Default value for Exiting Column through Query Analyzer

• Sachin Bhaygude

  SSC-Addicted

  Points: 418

  More actions

  June 10, 2004 at 4:20 am

  #108360

  Hello,

  How we set Default value for Exiting Column through Query Analyzer. Means i have one column with datatype smalldatetime in table, I want to set Default value for that column instead of adding new column into table. Its easy through Enterprise Manager but how we can do through Qurery Analyzer.

  Plese help me.

  Thanks in advance.

   

   

  
  Sachin Bhaygude

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  June 10, 2004 at 5:36 am

  #509819

  Here is some sample code for you

  CREATE TABLE tblTest

  ([Field1] CHAR(10) NULL) ON [PRIMARY]

  ALTER TABLE [tblTest] ADD

   CONSTRAINT [DF_tblTest_Field1] DEFAULT ('Hi') FOR [Field1]

  GO

  sp_help tblTest

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net