Database Diagram

  • Hi All,

    I have created database diagram in SQL Server 2008 two days back and it was

    created successfully. When i have tried to open it and make some modification for changes required to certain relationship and table. suddenly it became Readonly.

    it is not allowing me to select and of the table any of the relationship in diagram.

    Any of you have faced such problem with database diagram?

    Manoj

  • I don't use database diagram tool in SQL Server 2008 (or 2000 or 2005)

    I think they are very very bad, I use another tool called Visual Paradigm, much more intuitive and flexible.

  • Use Microsoft Visio. Its cool.

  • The reason behind it may be you have modified the table while defining the relationship between the tables such as change the null / not null property for the columns in the table. This will make the tables uneditable and convert the database in Readonly mode. To overcome this issue just close the diagram without saving it and refresh your database. Open the table structure, make the changes and then again open the daigram after refreshing the diagram.

    This time the database daigram will allow you the editing. 🙂

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply