Share via

Hi guys, I am looking to create an Entity Relationship Diagram in SharePoint.

Anonymous
2022-03-25T15:02:47.387+00:00

Hi guys, I am looking to create an Entity Relationship Diagram in SharePoint.

The option to "add relationships" or "add related tables" is greyed out when trying to create a Database Diagram in SQL Server Management Studio. Does anyone know a way to create relationships in a SharePoint Database using the generic tables SharePoint provides?

SharePoint Server
SharePoint Server
A family of Microsoft on-premises document management and storage systems.
2,400 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,010 questions
SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,973 questions
0 comments
Accepted answer
  1. Echo Du_MSFT 17,201 Reputation points
    2022-03-28T05:11:56.44+00:00

    Hello @Anonymous ,

    Welcome to Q&A Forum!

    You can use the Microsoft Visio to realize your needs.

    Visio supports multiple data sources for reverse engineering, including Excel workbooks, Access databases, SharePoint foundation lists, SQL Server databases, Exchange Server directories, Azure Active Directory information, and other OLEDB or ODBC data sources. This tool does not provide a feature to generate SQL scripts, so it should not be seen as a full database modeling tool.

    We suggest that you can go to the Visio help & learning Community to seek more professional help.

    Thanks,
    Echo Du

    ================================================

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bill Wilkey 0 Reputation points
    2024-12-04T10:23:44.4333333+00:00

    Create lists with an ID field and a Text field and use them as Lookup tables for other Lists. Works really well, especially with the automatic transport of other Table attributes.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.