SAP Knowledge Base Article - Preview

2546758 - How to change a column to NULL or NOT NULL - SAP IQ


When a table is created, each column is defined as allowing NULL values or not allowing NULL values.  How do you change this once the table is created?  Attempting to use ALTER TABLE gives the following error:

Could not execute statement.
Cannot enforce the NOT NULL constraint. Column b has NULL data. 
(dblib/db_column.cxx 1186)
SQLCODE=-1000063, ODBC 3 State="HY000"
Line 5, column 1



  • SAP IQ 16.1
  • SAP IQ 16.0


SAP IQ 16.0 ; SAP IQ 16.1


KBA , BC-SYB-IQ , Sybase IQ , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.