Kodyaz Development Resources

Monday, June 18, 2007 - Posts

• How to drop a column in a SQL 2005 database table which has a default constraint on it

  How to drop a column in a SQL 2005 database table which has a default constraint on it I have added a new column which has a default value on it by running the following ALTER TABLE ... ADD COLUMN ... DEFAULT .... syntax ALTER TABLE RISStatus ADD StatusForHavingRecord Read More posted Monday, June 18, 2007 12:18 PM by eralper | 0 Comments Filed Under: SQL