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, 2136🔥, 0💬
Popular Posts:
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Use "IF ... ELSE IF ..." Statement Structures in SQL Server Transact-SQL? "IF ... ELSE IF ......
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...