tutorial SQL Server -Add a column with a default value to an existing table in SQL Server
Wed Apr 11, 2018 5:17 pm
How can a column with a default value be added to an existing table in SQL Server 2000 / SQL Server 2005?
- Code:
ALTER TABLE {TABLENAME}
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL}
CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE}
WITH VALUES
Permissions in this forum:
You cannot reply to topics in this forum