Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Sybase
  2. Suggest New Category

How can we add a column to a table without altering the
same?

Question Posted / s.sandip

Answers were Sorted based on User's Feedback



How can we add a column to a table without altering the same?..

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

How can we add a column to a table without altering the same?..

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

How can we add a column to a table without altering the same?..

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

How can we add a column to a table without altering the same?..

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

Post New Answer

More Sybase Interview Questions

Explain coalesce.

0 Answers  

what is the architechure of sybase ASE?

2 Answers   ocbc,

Why am I running out of locks on the replicate side in sybase ?

0 Answers  

Explain index covering? List its merits.

0 Answers  

How can I tell the datetime my server started?

0 Answers  

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

2 Answers   L&T,

Is sybase a database? Explain.

0 Answers  

What is sybase used for?

0 Answers  

How to swap a db device with another?

0 Answers  

In sybase, we can have multiple users associated to same login ,each corresponds to different databases, right? how can we login to one database with corresponding user id?

3 Answers   ISRO,

What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

0 Answers  

State some of the criticism about sybase iq?

0 Answers  

For more Sybase Interview Questions Click Here
Categories