Subject | What SQL to use to retrieve all details of a given table |
---|---|
Author | Namit Nathwani |
Post date | 2005-04-02T07:59:55Z |
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
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