copy table

[xixi]

hi , i am using sql create table xxx like aaa including indentity

to copy a table , but if table aaa has primary keys specified and xxx
has the same column to specify primary key, how to copy this attribut
together to table xxx? (right now it is not) thanks

[ranger]

i need to copy a default table (surv) as a new table with a variable name...
all works ok but primary key is not carried over as a primary key. note that
default table (surv) has no data, just fields. <cfquery name='crtcusttbl'
datasource='survey_table'> SELECT * INTO #tblnm# FROM surv </cfquery>
because primary key 'tblID' was not made into a primary key, i took the field
off of the default table and added it as below... <cfquery name='crtcusttbla'
datasource='survey_table'> ALTER TABLE #tblnm# ADD tblID INTEGER NOT NULL
PRIMARY KEY ; </cfquery> how come i had to do this... is there any way to make
primary key an autonumber too? this is msAccess for now.