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™.
DROP ROW TYPE statementUse the DROP ROW TYPE statement to remove an existing named ROW data type from the database.
The RESTRICT KeywordThe RESTRICT keyword is required with the DROP ROW TYPE statement. RESTRICT causes DROP ROW TYPE to fail if dependencies on row_type exist.

The RESTRICT Keyword

The RESTRICT keyword is required with the DROP ROW TYPE statement. RESTRICT causes DROP ROW TYPE to fail if dependencies on row_type exist.

The DROP ROW TYPE statement fails and returns an error message if any of the following conditions is true:

The named ROW data type is used for an existing table or column.
Check the systables and syscolumns system catalog tables to find out whether any tables or data types use the named ROW data type.
The named ROW data type is the supertype in an inheritance hierarchy.
Look in the sysinherits system catalog table to see which named ROW data types have child types.

The following statement drops the named ROW data type employee_t:

DROP ROW TYPE employee_t RESTRICT