i want to insert a column in an already created table and at a very specific place. How can i do that through SQL.
The only way to do this is to drop and recreate the table. You can't insert a column at a specific place in the table.
It depends on the DBMS. Some have directive such as after/before in alter table statements.<BR><BR>
You can create a view that gives you the order you wish.
Hmm, thanks. I didn't know that <BR><BR>(and couldn't think of a reason someone wanted to implement this)