Archives of the TeradataForum
Message Posted: Fri, 16 Jul 2004 @ 17:17:14 GMT
| Subj: | | Re: If Exists Then ...Else .... |
| |
| From: | | Dempsey, Mike |
Queryman (SQL Assistant) does not support any kind of procedural logic. (When connected to Teradata that is. You can use procedural scripts
with SQLServer and some other databases by using the 'Execute Parallel' button.)
If you want to drop a table and then continue with other SQL (not caring if it was dropped, or simply didn't exist) you can clear the checkbox
'Stop query execution if an SQL error occurs' on the Query tab of the Options screen.
This tells Queryman to ignore the error (if the table did not exist) and simply continue with the rest of your script.
Mike Dempsey
Teradata Client Tools
| 
