Deleting a Column

Delete a column from the table. If the table has only one column, you cannot delete it.

Prerequisites

Database Version	Table Column Privileges
SAP Sybase IQ 15.3 and 15.4	Deleting a column without a primary key or unique constraint – Requires one of: DBA authority. Both ALTER permission on the table. You own the underlying table. Deleting a column with a primary key or unique constraint – Requires one of: DBA authority. Both ALTER and REFERENCE permission on the table. You own the underlying table.
SAP Sybase IQ 16.0	Deleting a column without a primary key or unique constraint – Requires one of: ALTER ANY TABLE system privilege. ALTER ANY OBJECT system privilege. ALTER permission on the underlying table. You own the underlying table. Deleting a column with a primary key or unique constraint – Requires one of: ALTER ANY TABLE system privilege. ALTER ANY OBJECT system privilege. Both ALTER and REFERENCE permission on the underlying table. You own the underlying table.

Database Version

Table Column Privileges

SAP Sybase IQ 15.3 and 15.4

Deleting a column without a primary key or unique constraint – Requires one of:

Deleting a column with a primary key or unique constraint – Requires one of:

SAP Sybase IQ 16.0

Deleting a column without a primary key or unique constraint – Requires one of:

Deleting a column with a primary key or unique constraint – Requires one of:

Task

In the Perspective Resources view, select the resource and select Resource > Administration Console.
In the Administration Console, expand IQ Servers > Schema Objects > Tables.
Select Tables or Global Temporary Tables.
Select a table from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties.
The Table Properties view appears.
In the left pane, click Columns and in the right pane, select a column and click Delete.

Warning! No confirmation prompt appears before the column is deleted.
Do one of the following:
- Click OK to update the database and permanently remove the column, and exit the Table Properties view.
- Click Cancel to cancel the deletion, restore the column, and exit the Table Properties view.
- Click Apply to update the database and permanently remove the column, but remain in the Table Properties view.