Select for stored procedures for parameters and return types

Database
Enthusiast

Select for stored procedures for parameters and return types

As a beginner to Teradata I am trying to pull down all sorts of metadata for our application. I am not having a problem with getting the proper Select to access all stored procedures of a data base, but my problem just lies in finding the parameters and returns types.

Than for each parameter, I was curious if there is some select to get access to the following.

  • For each parameter get:
    • name
    • type
    • data length
    • hasDefault
    • direction
Tags (1)
1 REPLY
Senior Apprentice

Re: Select for stored procedures for parameters and return types

You need dbc.ColumnsV:

SELECT  * FROM dbc.columnsv 
WHERE (DatabaseName, TABLENAME) IN
(
SELECT DatabaseName, TABLENAME
FROM dbc.TablesV
WHERE TableKind = 'P')