ADD column AFTER is not available in SAP DB.
The only way is to - rename the old table
- create the new one with the wanted columns in the wanted ordering
- insert into new table select from old table (or do the last two steps in one)
- do not forget to grant privs, create views, create indexes, create synonyms
for the new table with the old name
"same procedure as with every DBMS, James"
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
