View previous topic :: View next topic
|
Author |
Message |
fundu
New User
Joined: 05 Oct 2005 Posts: 2
|
|
|
|
I have a column defined as Not null.
can someone tell me what's the sql to be executed to make it not null with default? |
|
Back to top |
|
|
tam
New User
Joined: 02 Nov 2005 Posts: 12 Location: zz
|
|
|
|
I think first you've to drop that column and then add it as not null with default.
ALTER TABLE <table_name>
ADD COLUMN <column_name> <column_type>
NOT NULL WITH DEFAULT |
|
Back to top |
|
|
|