General MySQL Oracle SQL Server

"DROP TABLE" - Deleting Existing Tables in SQL Server

Q

How To Drop an Existing Table with "DROP TABLE" Statements in SQL Server?

✍: FYIcenter.com

A

If you want to delete an existing table and its data rows, you can use the "DROP TABLE" statement as shown in the tutorial script below:

SELECT * FROM tipBackup
GO
id  subject    description              create_date
1   Learn SQL  Visit dev.fyicenter.com  2006-07-01

DROP TABLE tipBackup
GO

SELECT * FROM tipBackup
GO
Msg 208, Level 16, State 1, Line 1
Invalid object name 'tipBackup'.

Be careful, when you use the "DROP TABLE" statement. All data rows are gone too.

 

⇒ Understanding and Managing Indexes in SQL Server

⇐ "sp_rename ... 'OBJECT'" - Renaming Existing Tables in SQL Server

⇑ Managing Tables and Columns in SQL Server

⇑⇑ SQL Server Database Tutorials

2016-11-15, 2580🔥, 0💬

General MySQL Oracle SQL Server