Copy a table in Access structure only with CF query

[jimWPX]

Hello,
I need to know how to create a new table by copying an existing table with the
table structure only in a query

Don't know the Syntax but

CREATE newtable FROM oldtable ( structure only )

Is there a way to do this in a query?

Thanks in advance

[Dan Bracuk]

You mean without knowing the old table's structure?

[jimWPX]

I actually worked it out. It may not be the right answer but it works

<cfquery datasource="#application.db#">
Select * Into admin_pass2 From admin_pass
</cfquery>

This makes a copy

<cfquery datasource="#application.db#">
Delete * FROM admin_pass2
</cfquery>

This empties it

[Jochem van Dieten **AdobeCommunityExpert**]

jimWPX wrote:

> I actually worked it out. It may not be the right answer but it works
>
> <cfquery datasource="#application.db#">
> Select * Into admin_pass2 From admin_pass
> </cfquery>
>
> This makes a copy
>
> <cfquery datasource="#application.db#">
> Delete * FROM admin_pass2
> </cfquery>

And if you want to do it in one statement:

SELECT *
INTO admin_pass2
FROM admin_pass
WHERE 0 = 1

Jochem

--
Jochem van Dieten
Adobe Community Expert for ColdFusion