Create database digram of schema query?

Question

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"?

Answer 1

Hi,

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.

---

Thanks,
Suresh
Please use Mark or Propose as Answer if my post solved your problem and use Vote As Helpful if a post was useful.

Answer 2

When 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