Archives of the TeradataForum

Message Posted: Fri, 01 Oct 2010 @ 13:21:27 GMT

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

I need to get the table DDL from inside of a stored procedure, but "showtable" statement is not supported within a stored procedure. I can't use the column "Requesttext" in dbc.tables either, since it has the alter statement instead of the DDL if the table has been altered. Is there a way I can get DDL from within a stored procedure?

Thanks,

Nazy

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