Make a column nullable in Ingres

Question

I would like to make a column nullable in Ingres Database, but I couldn't find the statement, or any tool that allow me to do this.

Anyone can help me?

---

Ingres Version: 9.2.1

Answer 1

So let's create a table with a NOT NULL field:

CREATE TABLE test ( field_1 CHAR(10) NOT NULL )

In order to convert that field so it allows NULL values you need this:

ALTER TABLE test ALTER COLUMN field_1 char(10) NULL

For reference the Actian Ingres SQL manual can be found here: Actian Ingres 2006 SQL Reference Guide

Answer 2

Use ALTER TABLE. Also, use the Ingres forums instead of Stack Overflow.