How to create table and delete it??

[Fekri]

Hi,

how to make table and also how to delete the table??

thanks

 

[PHV]

how to make table
either with a maketable query (SELECT ... INTO ...)
or with DDL code (CREATE TABLE ...)
how to delete the table
with DDL code (DROP TABLE ...)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Fekri]

Hi,

what is DDl code

how should made DDL code???
is it like DAO to have some procedure to write it??
and can I put DDL code in an event code???

thanks
ali

 

[PHV]

DDL is the part of SQL standing for Data Definition Language
You may execute such code with DoCmd.RunSQL or CurrentDB.Execute or ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886