Archives of the TeradataForum

Message Posted: Sat, 20 Dec 2003 @ 05:32:45 GMT

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

Hi,

I am very sure that lot of times we have a requirement in which we have to create the intermediate temp table before loading it and after execution of the complete job we drop it. My question is how efficiently we can check whether table exists or not. Actually if table exists then i will drop it and recreate it otherwise directly create it. I have to do through BTEQ. Your suggestions are valuable to me.

With Regards

Dheeraj GARg

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