All Forums Database
gajajnanpkini 1 post Joined 12/13
03 Dec 2013
get the list of System / Critical stored procedures in Teradata

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

Raja_KT 1246 posts Joined 07/09
03 Dec 2013

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.

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.