In article <[EMAIL PROTECTED]>,
Mischa <[EMAIL PROTECTED]> writes:
> I've got a similar request for other objects that do/do not exist.
> Maybe it's just that I got lazy using MSSQL, but it sure was convenient
> to have:
> IF object_id('WorkTable') IS NULL
> CREATE TABLE WorkTable(...
> etc.
I got lazy using MySQL, where it was convenient to have
CREATE TABLE IF NOT EXISTS tbl (...)
and
DROP TABLE IF EXISTS tbl
This is the only feature of MySQL I really miss.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])