Drop Table in Azure Data Studio

Dropping a tables from an Azure Data Studio Server and it deletes the physical disk files used by the tables.

Syntax : -
-- Drop a table called 'TableName' in schema 'dbo'
-- Drop the table if it already exists
IF OBJECT_ID('[dbo].[TableName]', 'U') IS NOT NULL
DROP TABLE [dbo].[TableName]

Example : - 
IF OBJECT_ID('[dbo].[sam]', 'U') IS NOT NULL
DROP TABLE [dbo].[sam]

" Or "   -- sam is the table name

DROP TABLE [dbo].[sam]

Post Author: adama