How can we add a column to a table without altering the
same?
Answer Posted / devraj
In Oracle - create nother table with new column
2. insert complete data into this
3. drop orignal table
4. rename the created table to orignal table
Is This Answer Correct ? | 12 Yes | 26 No |
Post New Answer View All Answers
How to compute database fragmentation in sybase?
How do I open sybase control center?
What is server replication?
What is the default size of master database in sybase?
Differentiate between ltm and repagent?
What is the default table size in sybase?
Why not max out all my columns sybase?
What does –i option do in sybase tools?
Does table partitioning require user-defined segments in sybase?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
What is the use of sp_helprotect in sybase?
How would you fix a munged log in sybase ?
Explain the structure of adaptive server enterprise?
How would you configure burn factor in sybase?
What causes re-resolution of a stored procedure in sybase?