Collections:
"ALTER TABLE ... DROP COLUMN" - Deleting Existing Columns in SQL Server
How To Delete an Existing Column in a Table with "ALTER TABLE ... DROP COLUMN" in SQL Server?
✍: FYIcenter.com
If you have an existing column in a table and you do not need that column any more, you can delete it with "ALTER TABLE ... DROP COLUMN" statement. Here is a tutorial script to delete an existing column:
ALTER TABLE tip DROP COLUMN create_date GO SELECT * FROM tip GO id subject description author 1 Learn SQL Visit dev.fyicenter.com NULL
As you can see, the column "create_date" is gone.
⇒ "sp_rename ... 'COLUMN'" - Renaming an Existing Column in SQL Server
⇐ "ALTER TABLE ... ADD" - Adding New Columns to Existing Tables in SQL Server
2016-11-17, 2220🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...