Monday, 15 April 2013

SQL SERVER : Remove / Drop a column from an existing Sql server table

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

No comments:

Post a Comment

Using Polybase to load data into Azure Synapse Analytics (SQL DW) from Blob Storage

Azure Synapse Analytics supports many data loading methods. The fastest and most scalable way to load is through Polybase technology. Polyba...