View previous topic :: View next topic
|
Author |
Message |
venky5436
New User
Joined: 06 Dec 2005 Posts: 12
|
|
|
|
Hi,
Can anyone please tell me the best,simple and fastest method to change a table column which has data in it from not null to null in DB2.
I have worked on it by exporting ,dropping recreating and importing. But i feel there is another simple way to do it.
This is on the AIX platform and V8.2.2. Your help will be highly appreciated.
Thanks,
Venky |
|
Back to top |
|
|
Gurmeet
New User
Joined: 22 Feb 2006 Posts: 46 Location: Pune
|
|
Back to top |
|
|
krish_mrt
New User
Joined: 15 Apr 2005 Posts: 12 Location: Chennai
|
|
|
|
Hi,
You can try this code...
I've been using this on db2 for iSeries...
Code: |
ALTER TABLE <table_name>
ALTER COLUMN <column_name> DROP NOT NULL |
The above code removes the NOT NULL constraint form the specified column. |
|
Back to top |
|
|
|