View Single Post

   
  #3 (permalink)  
Old 02-29-2008, 06:52 AM
Johan Vervloet
 
Posts: n/a
Default Re: changing the default value for a column

David Portas schreef:
> ALTER TABLE table_name
> DROP CONSTRAINT name_of_default_constraint


Thank you for the quick reply. But how do I know the
name_of_default_constraint? I created the default value like this:

alter table /table_name/ add default /default_value/ for /column_name/

Johan
Reply With Quote