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])