[PHP-DB] ?? If Table Exists, Drop Table, then Create Table ?? From: MrBaseball34 (mrbaseball34 <email protected>)
Date: 11/27/01

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. 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>