Archives of the TeradataForum

Message Posted: Mon, 16 Sep 2002 @ 14:21:35 GMT

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

Mayur,

If you are doing this thru Queryman, why do you need the CASE statements. You can just do a show table to see if the table exists, if it fails, go ahead and create the table.

If you are doing it some other way, you may be better off with the CASE or by checking a return code to see if the table exists.

Raghav..

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