How do I create a table in a database using coldfusion

Hi @Gabe272096886ts3 ,

In a discussion like this it will be helpful if you mention:

• the ColdFusion version and update level;
• the database brand and version;

Gabe, you'll generally not do that WITH ColdFusion, though you indeed can. More on that in a moment.

Instead, when a web app built with something like cf interacts with databases, that interaction is generally focused on querying, updating, inserting, or deleting data in tables that ALREADY exist. That's why most of what you find discuss those operations. 

But you can indeed do all that AS WELL AS create (or delete or modify) tables in a cf web application since most such web apps interact with a database via SQL--and sql supports both kind of operations. The former are generally referred to (mostly by academics) as DML (data manipulation language) while the latter is DDL (data definition language).

Just Google the create table sql command, and you should be on your way (assuming you have/configure cf to use the proper authority to manipulate the db definition that way). 

But really, you'll probably find it far easier to define a table (and it's fields/columns and indexes and relations) using a UI tool dedicated the task of querying or manipulating databases and their design. There are many such tools, free and commercial: some are devoted to a specific db server, while others are generic to any.

Finally, if you may have hoped that CF Builder could have helped you here, if you saw mention of it offering a query builder interface, well again that's focused really more on doing DML rather than DDL. So it too will not likely be the right tool for your task.

Hope that helps. I'm sure others will have more to say, and may counter my assertions. There are always many ways to do (and consider) things.