Menu
In Visual Studio's Server Explorer window there's a very nice feature that lets you see the DB objects grouped by schema:
It turns this object tree:
Data Connections -> MyServer -> Tables -> MyTable (MySchema)
Into this one:
Data Connections -> MyServer -> Schemas -> MySchema -> MyTable
I've been looking for this particular feature in SSMS but was unable to find it.
Please note I'm aware of SSMS object filters. It's better than nothing but not sufficient, as I'm often accessing objects from multiple schemas at once.
280
The easiest way to find all tables in SQL is to query the INFORMATION_SCHEMA views. You do this by specifying the information schema, then the “tables” view. Here's an example. SELECT table_name, table_schema, table_type FROM information_schema.
You can get a list of the schemas using an SSMS or T-SQL query. To do this in SSMS, you would connect to the SQL instance, expand the SQL database and view the schemas under the security folder. Alternatively, you could use the sys. schemas to get a list of database schemas and their respective owners.
The directory schema describes the types of data that can be stored in a directory. During schema design, each data element is mapped to an LDAP attribute, and related elements are gathered into LDAP object classes. Well-designed schema helps maintain data integrity.
If you want a free tool, SSMS Schema Folders (GitHub repo) is your solution. It does the job beautifully.
196
I love the idea of grouping by schema.
SQL Treeo SSMS Addin is an inexpensive tool that allows you to create your own table structure in the Object Explorer.
20
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
