create table with same structure from other table

[saran]

I want a query which creates a table with the same structure as other table.

Reply me plz. Thanks in advance

 

[manoj.mcans]

Hi,
there are two method of creating the same table
i.e By using Make Table query i.e
first select the table which ever you can to copy in the design view and then select Query->MakeTable and then type new table name ..New table will be created.
second: by using the SQL view
tablename_old is the existing table.
tablename_new is new table that you want .
select columnname into tablename_new from tablename_old

Might be this will help you.