|
Database | Welcome to the Teradata Forums.
Read the
guidelines on posting.
Email notifications and RSS feeds are available, and also a chronological list of all forum activity. |
|
|
Active Posters
|
I want to extract meta data for stored procedure from dbc tables something like this.
select
a.name AS [ParameterName],
a.parameter_id AS [ParameterID],
TYPE_NAME(a.user_type_id) AS [ParameterDataType],
a.max_length AS [ParameterMaxBytes],
a.is_output AS [IsOutPutParameter]
from
sys.parameters a
;