"DROP TABLE" - Deleting Existing Tables in SQL Server


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

✍: FYIcenter.com


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
id  subject    description              create_date
1   Learn SQL  Visit dev.fyicenter.com  2006-07-01

DROP TABLE tipBackup

SELECT * FROM tipBackup
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, 1263🔥, 0💬