You may create or drop (delete) tables using the functions create-table and drop-table.
Create or drop indexes using the functions create-index and drop-index.
To create or drop a view (that is, a derived table based on a query) use the functions create-view and drop-view.