0

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

19th Aug 2016, 7:29 AM
davidho
davidho - avatar
3 Antworten
+ 2
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.
11th Sep 2016, 5:43 AM
Janette Abrahams
Janette Abrahams - avatar
+ 1
you can do it only in create table statement
10th Sep 2016, 6:07 PM
Natalya Shtikel
Natalya Shtikel - avatar
0
yes u definitly can do that.. :)
21st Nov 2016, 3:52 AM
Arun Bhandari
Arun Bhandari - avatar