How is the funtiion DropTable used?

[steve728]

I forgot how to use the DropTable function. Can someone
help me?

Steve

 

[jrbarnett]

Hi,

Drop Table is an SQL command. The syntax is:

DROP TABLE tablename;

eg

DROP TABLE customers;

John

 

[steve728]

Thanks. Isn't there more to the syntax? If possible, please provide a complete example.

Steve

 

[jrbarnett]

Steve

That's it - all you have to do is wrap it inside a RunSQL or QueryDef statement.

eg
DoCmd.RunSQL "DROP TABLE tablename;"

If this sounds to simple to you, it may be that there was a sub or function created called DropTable, if this is the case though I would need the function prototype/source code for it to work out what it does and how it works.

John