Candy Hein Consulting

Dropping a table is equivalent to deleting a file. It will also delete all the data contained in that table/file.

In this post will describe on how to create a table (file) using IBM Access Client solutions.

Definition of keywords:

Schema Name	Schema is the library name of where you will be storing the file
Table Name	The name of the table (file)

Drop Table syntax

DROP TABLE schema_name.table_name;

Drop table example:

DROP TABLE mylibrary.employee;


In our example above:
Schema_name/Library Name = mylibrary
Table_name/File Name = employee