Stack Overflow
Stack Overflow

Questions tagged [database-diagram]

62 questions
29
votes
2 answers

Microsoft SQL Server vs. SQL Server Management Studio

What is the difference between Microsoft SQL Server and SQL Server Management Studio (SSMS) and how can I integrate SSMS in Visual Studio 2012 so I can use database diagrams?
hrskrs
  • 4,447
  • 5
  • 38
  • 52
16
votes
1 answer

create image for database diagram in sql server

I have created database diagram in sql server. But I have to take 15 more tables in db diagram. Then i take screenshot. But i can't take screenshot more than 5 table. So I take screenshot 2 or more times. If sql server is automatically create image…
PoliDev
  • 1,408
  • 9
  • 24
  • 45
14
votes
2 answers

How can I script SQL Server database diagrams?

How can I export SQL Server database diagrams as developer-friendly SQL scripts? By developer-friendly, I mean written in a way similar to the way a human would write them as opposed to the messy many-UPDATEs style used by existing solutions. (Note…
Sam
  • 40,644
  • 36
  • 176
  • 219
11
votes
2 answers

Turn off Database Diagrams in SSMS

I use the keyboard arrow keys to navigate the SSMS Object Explorer, and when I expand a database, the first two items are Database Diagrams and Tables. I usually want to get to Tables (or something below that). Out of habit, I use the arrow keys to…
Tim Ridgely
  • 2,400
  • 1
  • 18
  • 25
9
votes
3 answers

How to move Database Diagram from One Server to Another Server

I have created a new Database Diagram in Test Database and it is in sitde01 Server. Now I want to move it to another server. How do I migrate it to another server.
user556674
9
votes
2 answers

How do I update a database Diagram in Microsoft SQL Server Management Studio

I currently have the database diagram window open in Microsoft Server Management Studio 2014. Is there a way to "refresh" the view so that I can see a newly added foreign key constraint?
Jolley71717
  • 678
  • 1
  • 8
  • 20
9
votes
1 answer

Creating Database diagram in visual studio 2015

How do i create a database diagram in MS Visual Studio 2015? There is no option to create one.
Muneeb Rehman
  • 135
  • 2
  • 10
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
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
1 answer

How to model diamond like many-to-many relationship in database ERD

Legend: PK (Blue): Primary key FK (Green): Foreign key PFK (Blue): Primary Key and Foreign Key at the same time How to model a diamond like (if term is correct) relationship? Better to explain using a simplified example: There is organization,…
özüm
  • 1,166
  • 11
  • 23
6
votes
1 answer

Creating a database diagram crashes SSMS with a memory corruption error

I'm working in SQL Server Management Studio Express version. When I create database diagrams in SQL Server Management Studio, I get an error: Attempted to read or write protected memory. This is often an indication that other memory is…
Asp.net MVC
  • 97
  • 2
  • 6
5
votes
2 answers

What does a dashed / dotted relationship line represent in SQL Management Studio - Database Diagram

I'm looking at an existing database in Microsoft SQL Server Management Studio, and in the Database Diagram there is one relatioship that appears with a dashed or dotted line. The other relationships are all solid lines. What does the dashed line…
MattyG
  • 8,449
  • 6
  • 44
  • 48
3
votes
1 answer

Prevent EF 4.1 from deleting my database diagram

Is there a way to prevent Entity Framework Code-First from deleting my database diagrams when it is re-building my database?
anon
  • 4,578
  • 3
  • 35
  • 54
3
votes
1 answer

Is this Social Media Platform PostgreSQL Database design right?

Here is a design of the persistence of a simple Social Media Platform. Currently, there are these tables: Users: Main table of the database that contains the information of the users registered in our application. The data that will be stored in…
reymon359
  • 1,240
  • 2
  • 11
  • 34
1
2 3 4 5