The following script can be use to get the list of all Primary Key, Foreign Key and Unique Key. The following script can be used to get the list of all Indexes. Thanks Manish

The following script is used to create Data Dictionary for all tables. However these above script can be modified to get details of any specific schema. Thanks Manish