IBM PureData System for Analytics, Version 7.1

DROP TABLE

Use the DROP TABLE command to remove an existing table from a database.

Syntax

Syntax dropping a table:

DROP TABLE <table>[,<table>…]

Input

The DROP TABLE command takes the following input:

Table 1. DROP TABLE input
Input	Description
<table>	The name of the table to be dropped.

Outputs

The DROP TABLE command has the following outputs:

Table 2. DROP TABLE outputs
Output	Description
`DROP TABLE`	The table was successfully dropped.
`ERROR: Relation "name" does not exist`	The specified table does not exist in the database.

Privileges

You must be the admin user, the owner of the user, or your account must have the Drop privilege for the user who is the owner of the table or for the User object class.

Usage

The following provides sample usage.

To drop the tables films and distributors:

MYDB.SCH1(USER)=> DROP TABLE films, distributors;