Deleting a Table

Delete a table, global temporary table or proxy table from the database.

Prerequisites
Database Version Table Privileges
SAP Sybase IQ 15.3 and 15.4 You must have one of:
  • DBA authority
  • You own the table
SAP Sybase IQ 16.0 You must have one of:
  • DROP ANY TABLE system privilege
  • DROP ANY OBJECT system privilege
  • You own the table
Task
  1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
  2. In the left pane, expand IQ Servers > Schema Objects > Tables, and then select Tables, Global Temporary Tables, or Proxy Tables.
  3. Select one or more tables from the right pane and either:
    • Click the arrow to the right of the name and select Delete, or
    • From the Administration Console menu bar, select Resource > Delete.
    Use Shift-click or Control-click to select multiple tables.
  4. Click Yes to confirm deletion.
Parent topic: Tables
Related concepts
Table Columns
Table Permissions
Table Constraints
Table Indexes
Table Triggers
Table Partitions
Related tasks
Creating a Table with No Partitions in the IQ Main Store
Creating a Table with No Partitions in the IQ (Catalog) System Store
Creating a Table with a Hash Partition
Creating a Table with a Range Partition
Creating a Table with a Hash-Range Partition
Creating a Global Temporary Table
Creating a Proxy Table
Viewing Table Data in the Execute SQL Window
Generating Table DDL Commands
Moving a Table to Another Dbspace
Validating a System Store Table
Setting the Primary Key
Setting a Clustered Index
Merging Table Data from RLV Store with IQ Main Store
Calculating the Number of Rows in a Table
Moving Table Objects to Another Dbspace
Enabling or Disabling Row-Level Versioning in a Table
Viewing or Modifying Base Table Properties
Viewing or Modifying Global Temporary Table Properties
Viewing and Modifying Proxy Table Properties
Authenticating a Login Account for a Managed Resource
Related reference
Table Privilege Summary