 |
 |
Archives of the TeradataForum
Message Posted: Fri, 11 Mar 2005 @ 14:33:21 GMT
| 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
| |
