All Forums Database
gajajnanpkini 1 post Joined 12/13
03 Dec 2013
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
 

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.
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.