Drop Table Query

EasySQL · PostgreSQL

Problem

Write a SQL query to drop a table.

Use PostgreSQL syntax to remove the staging_orders table. The submitted SQL must also return a confirmation row so the execution result can be verified.

Output

Return one row with the column dropped_table.
The value must be staging_orders.
The table must be removed before the confirmation is returned.

Schema

staging_orders

Column	Type	Description
order_idPK	INTEGER	Unique staging order identifier
order_reference	VARCHAR(30)	External order reference
load_status	VARCHAR(20)	Current staging load status
source_system	VARCHAR(30)	System that supplied the staging record

Tablesstaging_orders

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.