List stored procedure parameters in Teradata database

Query below return all parameters of stored routines (stored functions and stored procedures) and details about it in MySQL database.


SELECT  T.DatabaseName,
        T.TableName AS ProcedureName,
        C.ColumnName AS ParameterName,
        CASE C.SPParameterType
            WHEN 'I' THEN 'IN'
            WHEN 'O' THEN 'OUT'
            WHEN 'B' THEN 'IN/OUT' END as ParameterDirection,
        C.ColumnType AS ParameterType
FROM    DBC.TablesV T
ON  C.DatabaseName = T.DatabaseName
AND C.TableName = T.TableName
WHERE   T.TableKind in ('P', 'E')
AND T.DatabaseName NOT IN ('All', 'Crashdumps', 'DBC', 'dbcmngr', 
    'Default', 'External_AP', 'EXTUSER', 'LockLogShredder', 'PUBLIC',
    'Sys_Calendar', 'SysAdmin', 'SYSBAR', 'SYSJDBC', 'SYSLIB',
    'SystemFe', 'SYSUDTLIB', 'SYSUIF', 'TD_SERVER_DB', 'TDStats',
    'tdwm', 'SQLJ', 'TD_SYSFNLIB', 'SYSSPATIAL')
ORDER BY    T.DatabaseName,


  • DatabaseName - name of the database
  • ProcedureName - name of the procedure
  • ParameterName - parameter name
  • ParameterDirection -parameter direction (IN, OUT, IN/OUT)
  • ParameterType - parameters data type. Some of possible values:
    • CF - Char
    • CV - Varchar
    • D - Decimal
    • DA - Date
    • F - Float
    • I2 - Small Int
    • I - Integer
    • AT - Time
    • TZ - Time with time zone
    • TS - Timestamp
    • SZ - Timestamp with time zone
    • All possible data types (look for Possible Values for ColumnType paragraph)


  • One row - represents one procedure parameter
  • Scope of rows: - all parameters for procedures
  • Ordered by - database name, procedure name

Sample results

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.