Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 11 Mar 2005 @ 14:33:21 GMT

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

Subj:   Re: SHOW Procedure
From:   Tewksbury, Kevin

Stored procedures are "stored" with in the database (owner, if you will) as a "table", although the table is not something that you can select against. This "table" contains the text of the body as well as the object code for the stored procedure. If you were to use Teradata Administrator (WINDDI) and you right click on the "owner" of the stored procedure and list all objects you would see it as a stored procedure, however, if you click on table space you would see it as a table.

Kevin R Tewksbury
Database Administrator
Teradata Certified Master
Limited Technology Services

  <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: 15 Jun 2023