Can I add a column at anywhere I want in the table?

Answer 1

when you add a new column via an alter table statement, the column will always go at the end. The order of the columns has no impact on the database design. And you can always use views or queries to show the columns in any order you prefer.

Answer 2

you can do it only in create table statement

Answer 3

yes u definitly can do that.. :)