Stack Overflow
Stack Overflow

Questions tagged [database-diagramming]

25 questions
136
votes
14 answers

Database Diagram Support Objects cannot be Installed ... no valid owner

I tried to create a database diagramm with SQL Server 2008, but an error occurs: Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database…
Rookian
  • 19,841
  • 28
  • 110
  • 180
103
votes
4 answers

Why is a database always represented with a cylinder?

This question came up today and I couldn't find any historical answer as to why a database is always represented as a cylinder. I am hoping someone in the stack world would know why and have a link or something backing it up.
Rodney S. Foley
  • 10,190
  • 12
  • 48
  • 66
18
votes
8 answers

How to generate a diagram of a very large database schema (SQL Server)

I have a very large database I need to diagram. The database is SQL Server 2008 on x64. It is large in that there are hundreds of related tables, each with up to 2000 fields (some are sparse), multiple relationships between tables (often hundreds…
tomfanning
  • 9,552
  • 4
  • 50
  • 78
8
votes
4 answers

Tools for discovering de facto foreign keys in databases?

A good way to quickly survey the information in a database is to apply a tool that automatically creates a database diagram of all tables and all relationships between them. In my experience, such tools use foreign keys as the relationships, which…
reinierpost
  • 8,425
  • 1
  • 38
  • 70
8
votes
1 answer

Hide relationship from a SQL Server database diagram

I am using SQL Server 2005 database with SQL Server Management Studio. Is there a way to hide a relationship between two tables in the diagram without actually deleting the relationship from the database? Any help will be most appreciated.
user179490
  • 155
  • 1
  • 1
  • 14
7
votes
1 answer

Enterprise Architect: Hide Foreign Key Labels in Database Diagram?

I am using Sparx Systems Enterprise Architect 7 Professional and I can not find a way to hide the labels from Foreign Keys Associations in Database Diagrams. Yes, I know I can right-click each of the connectors and use the "Set Visibility" option…
vmarquez
  • 1,379
  • 11
  • 21
7
votes
1 answer

How to create a Database Diagram in SQL Server involving 2 databases?

Is it possible to create a Database Diagram involving two databases in the same SQL Server project? I have a table in one database that I want to create a foreign key to another table in another database. I'm using MS SQLServer 2008 R2.
Al Lelopath
  • 6,448
  • 13
  • 82
  • 139
7
votes
1 answer

Enterprise Architect: Hide only some Foreign Key Labels to all connectors at once

I am using Enterprise Architect 9 and I want do hide some Foreign Key Labels in all connectors, but not all. I'm using Associate connector often, and when I set foreign keys, it shows some labels I do not want to see. I want to show numbers (Source…
QAstral
  • 89
  • 4
6
votes
2 answers

Is there a way to visually display a View in a database diagram in SQL Server 2008?

I would like to create a database diagram in SQL Server 2008 and have a View in the diagram. is there a way to do this?
Ken Burkhardt
  • 3,528
  • 6
  • 33
  • 45
6
votes
2 answers

Missing Diagram folder in Database Explorer at Visual Studio 2012

I was in a middle of designing a website when suddenly Database Diagram folder just disappeared from the Database Explorer. I have no idea what happened and what to do right now, as I desperately need it to continue my work - adding tables to…
Lemur
  • 2,659
  • 4
  • 26
  • 41
5
votes
3 answers

SQL Command Add Database Diagramming

Is there a tsql command on sqlserver 2008 which can be run in order to enable Database Diagramming instead of this dialog appearing: This database does not have one or more of the support objects required to use database diagramming. Do you wish to…
maxfridbe
  • 3,221
  • 3
  • 23
  • 13
3
votes
7 answers

What software should I use for manually drawing schema diagrams?

Our application has a fairly large, sprawling DB design, with 175 tables. Most tables are used by one or two primary features, and I'd like to create several little "mini-schemas" to describe the structure of different parts of the system to new…
Arkaaito
  • 7,347
  • 3
  • 39
  • 56
3
votes
1 answer

How to create a database diagram with Enterprise Architect and an Oracle database?

I need to create a database diagram in Enterprise Architect. I understand how I can create each table and add the columns by hand. But that will take me a really long time. The database is Oracle 11g and I use Oracle SQL Developer. Is there any way…
jeph perro
  • 6,242
  • 26
  • 90
  • 124
2
votes
1 answer

SQL - Export Database Diagram - SSMS 17

I am trying to export 3 database (DB) diagrams from one DB to another using SSMS 17. I have tried the solution suggested here: How to export a SQL Server 2008 Database Diagram to another DB? This solution is also recommended in several other…
Diego Ballén
  • 23
  • 1
  • 3
2
votes
1 answer

Schemaspy export?

I'm searching a way to draw a diagram for the complex database of my project. I found schemaspy by the question here, and it fits my need except for one thing: my database is quite complex so that it made a lot of arrow intersections, which make it…
Hoàng Long
  • 10,746
  • 20
  • 75
  • 124
1
2