opps, sorry, this will not work In MSAccess! Only MSSQL.... At 03:29 PM 18/05/01 -0700, you wrote: > <!--- check for existence of the table ---> > <cfquery datasource="#datasource#" name="check_for_table"> > SELECT TABLE_NAME > FROM INFORMATION_SCHEMA.TABLES > WHERE TABLE_TYPE = 'BASE TABLE' > AND TABLE_NAME = 'sometable' > </cfquery> > > >At 05:54 PM 18/05/01 -0400, Mike wrote: > >When creating a table how do you find out if it already exist in access > >using sql create table? > > > >Thanks > >Mike > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
