Alternative to ALTER in Sybase

Ganapathi
Ganapathi used Ask the Experts™
on
I have a table with 10 million records in production database. I want to add a column to the table. I provided a alter script to the production control team and they refused to run the command. They do not have the select into turned on in the database. What are the other options I can go with?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
create a script to rename the original table to other name(a dummy backup name). create a table with original name and add the column you wanted to add newly. insert the data from the backup table to the newly created table. Finally drop the backup table.

Since the data volume is high, you may have to use a batch logic to insert the data into the created table. Use WHILE loop or cursor.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial