Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: How to change de Creator Name of a table
 
From:   Coffing Christopher L

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019