7 replies
by ckeenan
by patricewag
by lo
Why would you want to put it in the code? I is normally a one-time change (or not too frequent, 6 moths to a year or more). Such changes lead to many othere issues depending on the database.
You should make design changes such as that as infrequently as possible. You should also take a look at all fields when you need to make a change and if possible make them all at the same time. May involve various code changes depending on what/where how. Remember to make same/similar change to any archive database, copies, tapes, etc. so you have a compatible throughout.
My $.02 worth.
by patricewag
by tim parkins
As mentioned above, it is not a good practice to perform such changes in the code. I don't believe it is possible to modify the size or datatype of an existing field using the ALTER TABLE statement. The only alternative if you insist on doing this in your code is to add a new column and delete the old one as you suggest.
I would strongly recommend NOT making these changes in your code.
by patricewag
by patricewag
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending