Published on: 09 Dec, 2020

How to drop a table in TSQL?

Tumblr Digg Google Plus

If you need to delete a table in TSQL using a code query. You firstly need to check if the table exists in the database. This will ensure you will only delete the table if it exists. We can use the built-in function EXISTS to check if the table exists. Then we use another built-in called DROP to delete the table.

In the below example, we have a table that existed in the database named Users. Only if the condition matches then it will perform the table deletion process.


IF EXISTS (SELECT * from dbo.sysobjects where id = object_id(N'Users') and OBJECTPROPERTY(id, N'IsTable') = 1)
BEGIN
	DROP TABLE Users
END

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.