Tuesday, November 16, 2010

Luana Lani Zipset Galleries

Add, Delete, Change column data type in sql server


to add a column ----------------------
--------

ALTER TABLE table_name ADD column_name datatype
To
------------------------------ ------------------------------
delete a column ALTER TABLE table_name

DROP COLUMN column_name ------------------------------
To change data type
------------- -----------------

ALTER TABLE table_name ALTER COLUMN column_name datatype

0 comments:

Post a Comment