Subject What SQL to use to retrieve all details of a given table
Author Namit Nathwani
Hi all

What kind of a SQL statement can we execute on a database to retrieve all
details (fields, indices, constraints, triggers, etc.) of the given table name.

Is this possible? Actually I would like to print or atleast view linear-ly
a given table's complete details for creation of a similar table.

Please advise.

Softwares for Indian Businesses at:

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.0 - Release Date: 31/03/2005