Archives of the TeradataForum

Message Posted: Thu, 21 Feb 2008 @ 10:30:23 GMT

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

<-- Anonymously Posted: Thu, 21 Feb 2008 10:19 -->

Hi Criaig,

Following code can be used if you are not sure about the existence of the table to be dropped.

     DROP  TABLE Tablename ;
     .IF ERRORCODE = 3807 THEN .GOTO NEXT1
     .IF ERRORCODE = 0    THEN .GOTO NEXT1
     .QUIT ERRORCODE

Regards

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