>> 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.
>

If you know what table it is, why do you have to extract the metadata?

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com