12 martie 2012 09:42
I have a huge database containing several tables and schemas.
So if I want to make a diagram of a schema ex dbo Is it possible to do this whit a query? I guess not? :s
Or in my "New Database Diagram" in SSMS can i filter out the other schemas and only see the dbo schemas tables in my "Add table view"?
12 martie 2012 09:49
As such there is no facility to filter out unwanted tables. But, There will be a work around. Check if you can create a dummy database with list of all related tables that belongs to you. And create a database diagram there. Hope this helps.
Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
12 martie 2012 14:01When you are creating a new database diagram in SSMS Object Explorer, you can just add one table and pull in the related tables (right click menu on table frame).
Kalman Toth SQL SERVER & BI TRAINING