Yes, this is possible... Create a table ============================================= <cfset newtable="John"> <cfset datasource="johnsdsn"> <cfquery name="Test" datasource="#datasource#"> CREATE TABLE[#newtable#] ( [InvoiceNum] text, [InvoiceName] text, [Date] text, [InvoiceTax] text, [InoviceType] text, ) </cfquery> You can do Drop Table, as well as Alter Table look at other SQL websites to learn about each of them. Nathan www.cftipsplus.com -----Original Message----- From: Jesse [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 12, 2000 3:22 PM To: CF-Talk Subject: how do you create new DB tables and Columns with CF say I had a access database with one table in it, and I wanted to dynamiclly create new tables within that DB based on user input. and once the new tables are created how can I create the columns in that table based on user input?.... Is this even possible? ---------------------------------------------------------------------------- -------------------- Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED] ------------------------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message with 'unsubscribe' in the body to [EMAIL PROTECTED]
