paultran00

<div>
thanks, if the tables have pk and fk, will it list them too?
</div>


thanks, if the tables have pk and fk, will it list them too?

<div>
The structure scripting in SSMS will list PKs and FKs.<br />
<br />
INFORMATION_SCHEMA views also contain this information. You may look at <br />
CONSTRAINT_COLUMN_USAGE<br />
CONSTRAINT_TABLE_USAGE<br />
REFERENTIAL_CONSTRAINTS<br />
etc.<br />
<br />
All these views are listed in SSMS under Views - System Views.
</div>


The structure scripting in SSMS will list PKs and FKs.

INFORMATION_SCHEMA views also contain this information. You may look at
CONSTRAINT_COLUMN_USAGE
CONSTRAINT_TABLE_USAGE
REFERENTIAL_CONSTRAINTS
etc.

All these views are listed in SSMS under Views - System Views.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a SQL SERVER 2016 database. &nbsp; How do I get a physical data model? &nbsp;<br />
<br />
I have Visio 2016...doesn't this have the ability to import from SQL SERVER?<br />
<br />
When I tried to use SQL SERVER to create the DATA BASE DIAGRAMS, I get the error &quot;You are not logged on as the database owner or system administrator. ... Certain edits require CREATE TABLE permission.
</div>
</div>


Hi,

I have a SQL SERVER 2016 database.   How do I get a physical data model?  

I have Visio 2016...doesn't this have the ability to import from SQL SERVER?

When I tried to use SQL SERVER to create the DATA BASE DIAGRAMS, I get the error "You are not logged on as the database owner or system administrator. ... Certain edits require CREATE TABLE permission.

How do I get a physical data model from a SQL SERVER 2016 database?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Visio is a diagramming and vector graphics application that is part of the Microsoft Office family that allows the user to create diagrams for organizational and planning purposes. The Premium edition has additional templates for more advanced diagrams and layouts, as well as capabilities intended to make it easy for users to connect their diagrams to data sources and to display their data graphically, as well as intelligent rules, validation, subprocess (diagram breakdown). one-step connectivity with Excel data, information rights management (IRM) protection for Visio files, modernized shapes for office layout, detailed shapes for site and floor plans, modern shapes for home plans, and IEEE compliant shapes for electrical diagrams.

Microsoft Visio

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.