Overview Sure, there are many tools out there which will automatically build a data dictionary for you from an existing schema. Some of those tools include Visual Studio, Toad, Oracle SQL Developer, ...

Query below lists all schemas in SQL Server database. Schemas include default db_*, sys, information_schema and guest schemas. If you want to list user only schemas use this script. Do you need a ...