Thursday 30 January 2014

MS SQL: ALTER

Syntex:
ALTER TABLE <table_name>
ADD <column_name> <datatype>
ALTER TABLE <table_name>
DROP COLUMN <column_name>
ALTER TABLE <table_name>
ALTER COLUMN <column_name> <datatype>
ALTER TABLE <table_name>
DROP COLUMN <column_name>
Example:

0 comments:

Post a Comment