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 |
What is sybase infomaker?
How do I make isql secure in sybase?
How do the blocker processes exist internally in sybase?
How would you configure burn factor in sybase?
What is the default table size in sybase?
Explain the features of sybase.
You need to remove duplicate rows from a sybase table. How would you do that?
What is raid and sybase?
How to check if sybase database is up and running?
What does –i option do in sybase tools?
How to start sybase database in windows?
How do I configure identities in sybase?