Is it possible to query a database diagram?

Question

Is it possible to query a database diagram to count how many table it contains? So I only want to know how many tables thats in a certain diagram?

Like

select *
from dbo.sysdiagrams as s
where s.name = 'dbo_diagram'

But with that im only getting diagramid, version etc..

Or something like this

 EXEC sp_MSforeachtable 'USE [?]; SELECT ''?'' 
  COUNT(*) FROM dbo.sysdiagrams as s
   where s.name = ''dbo_diagram'

Is it possible to query a diagram like this?

Answer 1

Hello,

The diagram is stored binary encoded in sysdiagrams, you can't query it directly.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Follow this link

http://bytes.com/topic/sql-server/answers/81534-script-save-export-sql-database-diagrams

http://forums.techarena.in/software-development/1295211.htm