Archives of the TeradataForum
Message Posted: Thu, 06 Jan 2005 @ 21:15:02 GMT
Recreate the table as the preferred user.
I would not suggest updating the Data Dictionary tables manually. Let Teradata do the work in that area.
I am betting that this request is a bit more complicated than that though... I am betting that the 1 table is large and the customer is not going to be able to recreate the table. If that is the case then.... (recreate the table anyway!) You are asking for trouble if you try to make a change to something that most people will never see.
If standards are that important at the creator level, then this should be an easy sell...
Here is the SQL to perform the task. Make sure you have enough permspace to accomplish the tasks.
create databasename.tablename_DBCCreator as databasename.tablename with data; rename table databasename.tablename to databasename.tablename_old; rename table databasename.tablename_DBCCreator to databasename.tablename;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|