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, 2130🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...