In SQL Server and PostgreSQL, the DROP TABLE statement removes the table.
SQL Server:
-- Drop table if exists DROP TABLE IF EXISTS tab1; /* Commands completed successfully. */
PostgreSQL:
-- Drop table if exists DROP TABLE IF EXISTS tab1; /* NOTICE: table "tab1" does not exist, skipping */
For more information, see SQL Server to PostgreSQL Migration.