Asp.Net Stuffs
Articles related to Ajax,C#.Net,Sql Server,etc.
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment