Ansicht
Dokumentation
SQL0196 - Column &3 in &1 in &2 cannot be dropped. ( OS/400 )
BAL_S_LOG - Application Log: Log header data PERFORM Short ReferenceThis documentation is copyright by IBM.
Message : SQL0196
Column &3 in &1 in &2 cannot be dropped.
Message Long Text :
Cause . . . . . : An attempt was made to drop column &3. The column cannot be dropped because a view, a constraint, a trigger, or an index is dependent on the column and RESTRICT was specified, or the column is part of the partition key, or the column is referenced by a text search index.
Recovery . . . : Specify CASCADE on the ALTER TABLE statement to drop the column and the views, constraints, triggers, and indexes that are dependent on it. If the column is part of the partition key, specify DROP PARTITIONING on the ALTER TABLE statement to remove the partitioning for the table. Try the request again. If the column is part of a text search index, the text search index should be dropped using the SYSPROC.SYSTS_DROP stored procedure.
Message File : QSQLMSG
Library Message File : QSYS2924
Vendor Master (General Section) General Material Data
This documentation is copyright by IBM.
Length: 3222 Date: 20240418 Time: 000409 sap01-206 ( 2 ms )