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

score 1 · Answer 1 · edited Mar 25 '15 at 21:39

1

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

edited Mar 25 '15 at 21:39

Brad Larson

answered Aug 27 '13 at 10:34

Roy

score 1 · Accepted Answer · answered Aug 04 '14 at 13:05

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

2 Answers2