how can i add new column between two existing columns in ms-access and sql server?
Do u want sql query for that?? I suppose....
for SQL_Server
********************
You can add a new field using ALTER TABLE statement
ALTER TABLE table_name ADD column_name datatype
Ex:
ALTER TABLE Employee ADD City varchar(30)
* All the capital letters are reserved words
For ACCESS
*************
The Microsoft Jet database engine does not support the use of ALTER TABLE,
or any of the data definition language (DDL) statements, with non-Microsoft Jet databases.
Use the DAO Create methods instead.
I suspect you have to do it in designer......