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,271 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,011 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,864 questions
0 comments No comments
{count} votes

Accepted answer
  1. Echo Du_MSFT 17,121 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 No comments

0 additional answers

Sort by: Most helpful