Saturday, August 23, 2014

How to remove column from an existing table in sql server?

Let's assume we have table with below populated data.


Now to remove column name "Extra" from the above table,use below query(without double quotes)

"alter table tblSample drop column Extra"


Now check the table data after executing above query.


No comments:

Post a Comment