How can we add a column to a table without altering the
same?
Answers were Sorted based on User's Feedback
Answer / shoaib
you can add new column by using CAST keyword.
Eg:
Suppose your existing table say #EMP contain the following
Columns:
empid,
empname,
empaddr
you want to add empsal columns.
Query:
select
empid,
empname,
empaddr,
(null as decimal(18,2))empsal
from #EMP
into #EMP1;
Is This Answer Correct ? | 18 Yes | 10 No |
Answer / sandip
Thanks Devraj.
But i just mean is their any way of adding colum without
using alter statement?
Is This Answer Correct ? | 8 Yes | 9 No |
Answer / 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 |
Answer / 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 |
Explain autosys. Why do you need it.
How do I find the oldest open transaction in sybase?
A single operation is failing to escalate?
What do you mean by sybase iq?
What happen when we delete the table using trigger?
What is open client in sybase?
How do I bcp null dates in sybase?
What sybase central?
What will happen if we create more indexes on a sysbase iq table?
Explain bind cache?
You need to add a notnull column in a table by using alter command (without using default command). How would you do that?
How to clear tempdb when the tempdb gets filled in sybase?