|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Migration problem - where is ADD columnName AFTER command?
From: Sven Köhler (skoehler
upb.de)
Date: Thu Jul 03 2003 - 04:34:44 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> 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
sapdb.generallistserv.sap.com
http://listserv.sap.com/mailman/listinfo/sapdb.general
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]