![]() There are three versions of Toad for SQL Server. After working with Toad for SQL Server for a few days, I'm finding myself thinking about making the switch. ![]() Service packs and SQL Server 2008 have ameliorated my sentiments a bit, and SSMS is much better than the tools that ship with most other database platforms, but I've long wondered whether I'd jump ship if I could find another suitable product that met my needs. To me, it's always felt like a last-minute decision made by marketing folks who were more interested in forcing the "Studio" branding than developer and DBA productivity. If diagram is unreadable, you can try to reorganize it by clicking on the Automatically rearrange button.I've never been that impressed with SQL Server Management Studio (SSMS). All related tables should be added, but this works in both relation directions, so this option adds child tables (tables that reference to our specific table) too. next drop interesting table from Object Explorer to the diagram workspace.set Reference Depth to 1 - this step will automatically add related tables (set to 2 will add related tables of related tables etc.).In order to do this click on Diagram button from main menu or from open by Tools -> Diagram.ĭatabase diagram window will appear with Object Explorer. To see related tables to specific table we can use diagram generator Toad provides. Except above you can find there constraint description too. If you click on foreign key row at the bottom will appear FK’s details like Columns and Properties with parent table. ![]() You can find now Foreign Keys in the list of constraints by looking at the Type of constraints. Right click on the found table and select Send to -> Object Details Open Find tool and search for appropriate table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |