Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

change the NOT NULL attribute

Status
Not open for further replies.
beatsme

beatsme

IS-IT--Management
Dec 10, 2003
2
US
jell-o
how can i change the NOT NULL attribute of an existing column in interbase???
thanks
moises
 
Sort by date Sort by votes
You have to erase the column and recreate it.

Copy the data first to a temporary column, drop the column to be modified, recreate it and copy the data from the temporary column. Steven van Els
SAvanEls@cq-link.sr
 
Upvote 0 Downvote
Use InterBase Workbench, open the Table Editor, click the flag and save.


If you're changing from NULLable to NOT NULL, make sure to fill the column with data.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ale2
  • Locked
  • Question
Interbase Server did not start within the expected time_any solution
Replies
0
Views
112
ale2
ale2
cyprus106
  • Locked
  • Question
Trim() feature not working??
Replies
1
Views
139
CHDH
CHDH
Kocky
  • Locked
  • Question
FindFirst and FindNext not working on removable disk
Replies
1
Views
126
Kocky
Kocky
cyprus106
  • Locked
  • Question
The Handle is Invalid in IBMgr
Replies
0
Views
86
cyprus106
cyprus106
aim22
  • Locked
  • Question
Username and password are not defined
Replies
1
Views
145
IBJulie
IBJulie

Part and Inventory Search

Sponsor

Back
Top