Remove a column from a Sql server table use the following code :
Syntax :
ALTER TABLE [table_name]
DROP COLUMN [column_name]
E.g. :
ALTER TABLE tbl_main
DROP COLUMN App_Id
Syntax :
ALTER TABLE [table_name]
DROP COLUMN [column_name]
E.g. :
ALTER TABLE tbl_main
DROP COLUMN App_Id
No comments:
Post a Comment