Archives of the TeradataForum
Message Posted: Tue, 17 Sep 2013 @ 10:22:44 GMT
Well, this doesn't answer the question and it doesn't work, too :-)
As there's no built-in way (beside SHOW PROCEDURE xy) to get the source code of a SP, it's up to the developer of the SP to determine the order.
Otherwise Teradata's Metadata Services (MDS) should be able to return that info.
Of course, all will fail if the SP is created without source code (ok, in this case you can't recreate it).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|