Archives of the TeradataForum
Message Posted: Wed, 16 Jan 2013 @ 13:57:24 GMT
No, there is no SQL statement available to rename a database (or user).
Some alternate ways to accomplish this are:
1. Use bteq / show table(s) /.export to host file /modify DDL from show table(s)/ .run file = modified DDL/SQL to create new
table(s) / then insert into
2. Use ARCMAIN, to ARCHIVE the DB and then COPY it to the new one.
In all cases, any attributes associated with the tables/DB's being moved would need to be "manually" redone or recreated via SQL scripting. This would include attributes such as access rights, and referential integrity as well as any join indexes.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|