Archives of the TeradataForum

Message Posted: Tue, 17 Sep 2013 @ 10:22:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

narayan.murthy wrote:

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).

Dieter

	<Prev	Next>		<<First	<Prev	Next>	Last>>