or SP_TABLE '"Table_Name"'
Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott Thornton Sent: Monday, May 16, 2005 2:09 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Test for SQL Table Hi, 1. Yes there is. 2. (MSSQL 2000) if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[some_tabe_name]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) select 'the table exists' GO Scott Thornton, Programmer Application Development Information Services and Telecommunications Hunter-New England Area Health Service Phone RNH +61 2 49236078 Fax +61 2 49236076 [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 16/05/2005 1:57:07 pm >>> Couple more Monday Questions... Is there a way to dynamically generate a database schema using CF? Is there a way to test to see if a table exists? Chad who is listening to techno moosak --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
