Archives of the TeradataForum

Message Posted: Thu, 05 Dec 2002 @ 15:15:27 GMT

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

I want to drop the table if it exists in mload script.

IF exist(dev.inslogtable)
then drop table dev.inslogtable
endif

Please help me with syntex and where to put it. For some reason successful run of mload script does not drop this table which is my logtable and since this log table is not dropped I can not run the script again.

THANX

Mayur

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