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, 2156🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...