DROP TABLE - Kinetica Docs

Removes an existing table. All dependent views, materialized views, streams, and SQL procedures will be dropped.

DROP TABLE Syntax

DROP TABLE [IF EXISTS] [<schema name>.]<table name>

Any tables with foreign keys that target a given table must be dropped before it can be dropped.

Parameters

IF EXISTS

Optional error-suppression clause; if specified, no error will be returned if the given table does not exist

Name of the schema containing the table to remove

Name of the table to remove

⌘I