How to drop a table if it exists? – sql server

To drop a table only if it exists in SQL Server, use the IF EXISTS clause with the DROP TABLE statement. Here’s the syntax:

Example:

This ensures the table is dropped if it exists, avoiding errors if the table is not present. For older SQL Server versions (before 2016), use:

Example:

This approach checks for the table’s existence before dropping it.