get the list of System / Critical stored procedures in Teradata

Database

get the list of System / Critical stored procedures in Teradata

Hi ALL

I wanted the list of  System / Critical stored procedures in Teradata .

Working on a tera data document and need this info

If anyone can provide this info it will be great

Gajanan

1 REPLY
Enthusiast

Re: get the list of System / Critical stored procedures in Teradata

Hi Gajanan,

You can run the query : select * from dbc.tables where tablekind='P' . The field creatorname may help you identify the critical  one as per your organization policy. Check the other fields too like comment etc that may help you.

Cheers,

Raja