Should I create the support objects required to use database diagramming?

Question

When I click on database diagrams in SQL Server Management Studio 2008 R2, some databases tell me the following message:

This database does not have one or more of the support objects required to use database diagramming. Do you wish to create them?

Are there any concerns (i.e. security?) in doing so? The databases aren't mine

Answer 1

Based on the comments, it adds [dbo].[sysdiagrams] to the database's system tables node. The objects below are also added to the database (source).

Please weigh the consequences. Is this a development or a production database? If you add these objects, with your current deployment model, do they get deployed to higher environments? Is the database in a secure location? Does the database contain sensitive information?

Objects:

• sp_upgraddiagrams

• sp_helpdiagrams

• sp_helpdiagramdefinition

• sp_creatediagram

• sp_renamediagram

• sp_alterdiagram

• sp_dropdiagram

• fn_diagramobjects (in question)

• sysdiagrams dt_properties (?)