Similar to this question, is there a way to visually display a database view in a database diagram?
Is there a way to visually display a database view in a database diagram?
1.5k views Asked by katzbatz At
1
There are 1 answers
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in DATABASE-DIAGRAM
- How to fix SQL Server database diagram error "Cannot execute as the database principal because the principal 'dbo' does not exist"?
- Entity Relation Diagram / Database Diagram (MySQL)
- Power BI Chord visual: link tables with same column name
- SQL server tables not showing relation in Diagram
- ERD or MCD one-to-many diagrams
- Correct relations to Loans table?
- Need help understanding the correct way of making relations between many to many tables
- Is this Social Media Platform PostgreSQL Database design right?
- Generate diagram from Django Model with dragable elements
- Is there any way generate database-design diagram of databases using C#
- SQL Management Studio - Database Diagram does not show every table created
- Can I display custom tags of columns in a database diagram?
- Azure SQL and Visio 2019 Plan 2 Database Reverse engineering wizard Fails
- How can i generate a databasediagram in Oracle Application Express?
- How to resize attribute boxes in Visio attributes
Related Questions in DATABASE-DIAGRAMMING
- SQL - Export Database Diagram - SSMS 17
- SQL Database Diagram - SQL Server 2014?
- Is there a way to visually display a database view in a database diagram?
- Can't connect SchemaCrawler to SQL Server
- How to create a Database Diagram in SQL Server involving 2 databases?
- How to generate database diagram to a PDF in Microsoft visio?
- Enterprise Architect: Hide only some Foreign Key Labels to all connectors at once
- How to create a database diagram with Enterprise Architect and an Oracle database?
- Missing Diagram folder in Database Explorer at Visual Studio 2012
- Schemaspy export?
- Access 2003 is not showing Database Diagram option
- Is there a way to visually display a View in a database diagram in SQL Server 2008?
- Tools for discovering de facto foreign keys in databases?
- how to create a database diagram in sybase
- How to generate a diagram of a very large database schema (SQL Server)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Yes, though not using SSMS's Database Diagrams.
My solution for this is Microsoft BI's Data Source View (DSV). This requires that you have Microsoft's BIDS (Business Intelligence Development Studio), a component of SQL Server Standard (or higher) installed.
BIDS 2005 through 2016 should all work and provide the same basic functionality.
Alternatively, if you want access to a free version of the toolset, you can download and install SQL Server Express with Advanced Services ( basically SQL Express with Reporting Services added), though I have not worked with this version to verify.
Here's a DSV of Microsoft's AdventureWorks2008 OLTP database. This image shows an example of what one can do with SQL views in DSVs. In it, I replaced the Employee table with the vEmployee View (gave it a friendly name of 'Employee') that exists in the database, and added logical primary key and foreign key relationships that mirror the PK/FKs of the underlying physical table.
Note that all changes made in a DSV are logical and therefore isolated to the DSV file itself and do not impact the database directly.