Adding a new column 
Author Message
 Adding a new column
Hi,

Is it possoble to Add a colum C1 to a Table after another
Column C2?if it's possible how can i do that?

thank you for any help!
Abdu



Sat, 29 May 2004 06:16:41 GMT
 Adding a new column

If you just want to add a column:

alter table YourTable add C1 int not null....

If you want it in a specific order you either have to drop and recreate the
table, or insert the column via Enterprise Manager which will drop and
recreate the table for you.

Zach


Quote:
> Hi,

> Is it possoble to Add a colum C1 to a Table after another
> Column C2?if it's possible how can i do that?

> thank you for any help!
> Abdu



Sat, 29 May 2004 06:23:10 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Drop a column and add a new column

2. Adding a new column to a specific position

3. replication and adding a new column help, please?

4. adding a new column => corrupt view

5. Vertical replication: Can I add a new column?

6. add a new column into the middle of an existing table

7. Add a new column on a certain position

8. Adding a new column

9. problem with adding a new column

10. To add a new column to table A, how to avoid the existed same name column?

11. Trouble adding a new column and updating column with data.

12. Need to add a new column to a table with a long column at the end of it.


 
Powered by phpBB® Forum Software