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.




Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://ahmedabad.sancharnet.in/vso_ad1/
namitbn@...
___________________________________________


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