Subject Re: How to extract a single table metadata using API?
Author Chau Chee Yang
> Perhaps if you explain better your needs someone could suggest a better
> solution.

My problem is this:

I have a table with over 6 milions rows. In one the function in my application, I will purge all rows and re-insert new rows to the tables. After I run "DELETE FROM table", all further operations will become very slow as the database is sweeping the database.

The fastest way to avoid the sweeping happen is drop the table and re-create the table again. That's the reason why I need a solution to extract the metadata of a table.