Alter table statement in sql server

If you want to add some column in a table. You might use the sql server management tool or other tools to manage this with their’s easy UI. But if you are in some situation that haven’t the management tools to manage the table. You might use the sql script to do that. It’s call Alter Table.

Actually I found a problem with web sql management tools (with parallels Plesk panel) because when I change a column in table then the owner of table will change and the application in this server cann’t connected with this table. This’s my serious problem. -*-

Hope you enjoin to use this solution.

To add a column in table :
ALTER TABLE table_name
ADD column_name datatype

To drop a column in table :
ALTER TABLE table_name
DROP COLUMN column_name

To change a datatype of column in table :
ALTER TABLE table_name
ALTER COLUMN column_name datatype