Hi,
How do I rename a diagram in SQL Server 7 ?
TIA
Miguel Oliveira
If you don't find any other method, you could always update the dtproperties
table directly. Below is an example which can be executed in the Northwind
database:
update dtproperties set value = 'NewName' where value = 'Relationships'
--
Tibor Karaszi, Cornerstone Sweden AB
MCDBA, MCSE, MCSD, MCT, SQL Server MVP
Please reply to the newsgroup only, not by email.
Quote:> Hi,
> How do I rename a diagram in SQL Server 7 ?
> TIA
> Miguel Oliveira
Ill use your solution !
Its a pitty Microsoft didnt include a Rename option in the context menu
for the diagrams.
Well, may be it isnt a requirement to get the "Ready for Windows" logo ;-)
Best regards,
Miguel Oliveira
> If you don't find any other method, you could always update the
dtproperties
> table directly. Below is an example which can be executed in the Northwind
> database:
> update dtproperties set value = 'NewName' where value = 'Relationships'
> --
> Tibor Karaszi, Cornerstone Sweden AB
> MCDBA, MCSE, MCSD, MCT, SQL Server MVP
> Please reply to the newsgroup only, not by email.
> > Hi,
> > How do I rename a diagram in SQL Server 7 ?
> > TIA
> > Miguel Oliveira
> Ill use your solution !
> Its a pitty Microsoft didnt include a Rename option in the context menu
> for the diagrams.
> Well, may be it isnt a requirement to get the "Ready for Windows" logo
;-)
> Best regards,
> Miguel Oliveira
> > Miguel,
> > If you don't find any other method, you could always update the
> dtproperties
> > table directly. Below is an example which can be executed in the
Northwind
> > database:
> > update dtproperties set value = 'NewName' where value = 'Relationships'
> > --
> > Tibor Karaszi, Cornerstone Sweden AB
> > MCDBA, MCSE, MCSD, MCT, SQL Server MVP
> > Please reply to the newsgroup only, not by email.
> > > Hi,
> > > How do I rename a diagram in SQL Server 7 ?
> > > TIA
> > > Miguel Oliveira
1. How to rename database diagram?
How to rename database diagram in SQL Server 7?
Thanks.
Michael
2. Very Large databases, backups, etc.
3. How to rename a Diagram (Enterprise Manager)
4. Tuning SQL
5. How do I rename a diagram in SQL Server 7 SP4?
6. Whats a Dependency file & how to use it with Setup wizard ??
7. Diagrams lost after renaming tables
8. Dynasets vs Tables...HELP!!!
10. Multiple Instance of Table in Diagram
11. How do I Diagram entire project
12. Diagrams lost during Copy Database Wizard
13. SQL Server Database Diagrams