Archives of the TeradataForum

Message Posted: Thu, 06 Jan 2005 @ 21:15:02 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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;

Chris Coffing
Air Force Knowledge Services (AFKS)
Lead DBA Operations & Support
Teradata Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>