-
how to insert a new column between 2 column in a Table.This is for for MS SQL Server
hi,
how to insert a new column between 2 column in a Table.This is for for MS.
thx
-a
-
You have to drop and recreate the table. You can do it from enterprise manager which drops and recreates in the background.
-
so is it easier to create the column as the last coloumn of the table, do we need to drop the table for that too.
-
alter table tablename add
will add the column at the end.
look in syscolumns for colorder
-
If you are using sql 7.0 or 2000 you can add a column using alter table syntax without dropping a table.
-
insert a new column beteen two columns in a table in mysql
alter table <tablename> add column <column name> datatype after <column name>
-
alter table <tablename> add column <column name> datatype after <column name>
-
insert a column between two columns
Originally Posted by aphagwani
hi,
how to insert a new column between 2 column in a Table.This is for for MS.
thx
-a
alter table <tablename> add column <column name> datatype after <column name>
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|