How can you add column after table creates in sql server 2005?

Answer 1

plz reply me argent

You can do it through Management Studio by right clicking on the table that you want to add the column to and select design.

Or you can run a ALTER TABLE statement

ALTER TABLE <TableName>

Add <NewColumnName> <DataType> <DefaultValue> <NULL or NOT NULL>

Keep in mind you do not need to specify a Default Value. Also note that it will drop to the bottom of the column list based on ordinal position.

ALTER TABLE ErrorLog

Add IsDeleted BIT DEFAULT (0) NOT NULL