Sql server 2008 database chart search table name

Question

I have a SQL Server 2008 server with a database containing up to 100 tables. I created a database diagram with all the tables because I want to get an overview of the database.

My question is: how can I quickly find the right chart, are there any search functions related to finding charts?

Answer 1

In SQL Server, charts are stored in the sysdiagrams table, which is created whenever a chart is created. The table definition is as follows.

CREATE TABLE [dbo].[sysdiagrams](
    [name] [sysname] NOT NULL,
    [principal_id] [int] NOT NULL,
    [diagram_id] [int] IDENTITY(1,1) NOT NULL,
    [version] [int] NULL,
    [definition] [varbinary](max) NULL)

Along with the table, several stored procedures are also created.

• sp_alterdiagram
• sp_dropdiagram
• sp_creatediagram
• sp_renamediagram
• sp_helpdiagramdefinition
• sp_helpdiagrams
• sp_upgradediagrams

sp_helpdiagrams .

Answer 2

SQL Server 2008 - , , . .