Database Tables Creation

[webhead_1]

With Coldfusion 7.0 can you create a new table within a MS-SQL database, and if so where can I find some documentation on that process?

[philh]

Books On Line. Look it up on msdn.microsoft.com. Also search these forums for the statement "CREATE TABLE".

[Code_Guy]

This creates the table:

<cfquery datasource="foo">
CREATE TABLE myfoo(
foo1 (12),
foo2 bit DEFAULT 0,
foo3 nvarchar (500)
)
</cfquery>

This will check for its existence:

<cfquery datasource="foo" name="qchkfoo">
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'myfoo'
</cfquery>

and drop it:

<cfif qchkfoo.recordcount GT 0>
<cfquery datasource="foo">
DROP TABLE myfoo
</cfquery>
</cfif>