Drop column in sqlserver using alter table syntax
by
Thamilselvanj
on
Jan 15, 2012
Category:
SQL Server
|
Views:
32
|
Points:
25
|
Silver ★
|
|
|
To drop a column in sql server, we can use alter table syntax to drop any column from sql server
table as shown below.
ALTER TABLE table_name
DROP COLUMN column_name --To drop one column
ALTER TABLE table_name
DROP
(column_name1,column_name2) -- To drop many columns
sample query to drop column.
ALTER TABLE emp_name
DROP COLUMN modified_by;
GO
|
Like this code? Bookmark and Share:
|
|
|
|
No Response found!
|
|
|
|
|