How can we add a column to a table without altering the
same?
Answer Posted / sanjay rawat
In oracle,
1. take data in new table from existing table
2. add a new column in new table by using alter command
3. drop existing table
4. rename new table with existing table name
5. Check by select query
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How to clear tempdb when the tempdb gets filled in sybase?
What is the command for quitting from sybase?
What will you do if a replication thread goes down?
Differentiate between clustered and non-clustered index.
Are there any alternatives to isql in sybase?
What is open server in sybase?
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?
You need to purge data from audit database. What will you do?
How do you view log files in sybase?
How do I make isql secure in sybase?
What are the operating systems in which sybase could take its presence?
List different types of sybase index.
Can two tasks be assigned to the same partition in sybase?
Explain the structure of adaptive server enterprise?
Is sybase open source?