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