Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
ALTER TABLE statementUse the ALTER TABLE statement to modify the schema of an existing table.
DROP Column ClauseUse the DROP Column clause to remove one or more columns from the schema of a table.

DROP Column Clause

Use the DROP Column clause to remove one or more columns from the schema of a table.

This syntax fragment is part of the ALTER TABLE statement.

DROP Column Clause


Element	Description	Restrictions	Syntax
column	Name of a column to be dropped	Must exist in the table. No fragment expression can reference the column, and it cannot be the last column in the table.	Identifier

You cannot issue an ALTER TABLE DROP statement that would drop every column from the table. At least one column must remain in the table.

You cannot drop a column that is part of the fragmentation key of a fragmentation strategy.

A column that is protected by a security label can be dropped by the ALTER TABLE DROP statement, but the user must be DBSECADM and must also hold the usual CONNECT, RESOURCE, and ALTER access privileges for modifying the schema of the table.