What is Teradata conversion for this statement?
SELECT COUNT(*) as SPs_Count FROM sys.objects WHERE type = 'P'?
especially what is sys.objects equal in teradata?
sometimes it is easier to ask the business question instead of posting other DB systems code.
I assume you want to count the SP in the system.
dbc.tables where tablekind = 'P'
would be the source and condition.
where there exists also external stored procedures....
Check the list of available tableKInd (- so sad that it is still called table and not object :-)) from the documentation
A Aggregate function
B Combined aggregate and ordered analytical function
Data Dictionary, Release 16.00
389Appendix A: View Column Values
C Table operator parser contract function
E External stored procedure
F Standard function
H Instance or constructor method
I Join index
K Foreign server object.
K is supported on the Teradata-to-Hadoop and Teradata-to-Teradata
L User-defined table operator
N Hash index
O Table with no primary index and no partitioning
P Stored procedure
Q Queue table
R Table function
S Ordered analytical function
T Table with a primary index or primary AMP index, partitioning, or both.
Or a partitioned table with NoPI
U User-defined type
Y GLOP set
1 A DATASET schema object created by CREATE SCHEMA.