Hi, All MySQL version higher than 3.22 support the following syntaxis DROP TABLE IF EXISTS tbl_name
HTH Dobromir Velev -----Original Message----- From: MrBaseball34 <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, November 27, 2001 18:37 Subject: [PHP-DB] ?? If Table Exists, Drop Table, then Create Table ?? >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: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
