?? If Table Exists, Drop Table, then Create Table ??
| From: | MrBaseball34 | Date: | Tue, 27 Nov 2001 16:36:53 +0000 |
| Subject: | ?? If Table Exists, Drop Table, then Create Table ?? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14610@lists.php.net to get a copy of this message | ||
Table Creation Script from SQL Server...
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[Orders]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Orders]
GO
CREATE TABLE [dbo].[Orders] (
[OrderID] [int] IDENTITY (1, 1) NOT NULL,
.
.
.
.
);
GO
Is there anything like the first line from mySQL?
I need to check if a table exists and drop it if it
does so it can be recreated. I do not have access to
any admin facilities on my host so I need to be able
to do this in a script I can modify.