Yeah,
DROP TABLE employees
CREATE TABLE employees
;-)
Craig
-----Original Message-----
From: Soma Interesting [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 04, 2001 1:40 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Test for existence of Table
Can I test for an existing table before issuing the "CREATE TABLE" command?
IF EXISTS employees{
DROP TABLE employees
}
CREATE TABLE employees
Can you provide an example of this. I couldn't find this in the manual or
Bruce's book - did I not look hard enough ? :)
- - - - - - -
- - - -
WARNING: Some experts believe that use of any keyboard may cause
serious injury. Consult Users Guide.
[EMAIL PROTECTED]
