Answer the question
In order to leave comments, you need to log in
How to edit relationships between DB tables in VS 2012?
I can't edit Relationships between tables
. I can't open the relationship editing window.
Did according to the article
Answer the question
In order to leave comments, you need to log in
Did it like this:
CREATE TABLE [dbo].[UserRole] (
[Id] INT NOT NULL,
[UserID] INT NOT NULL
REFERENCES [dbo].[User] (Id)
ON DELETE CASCADE
ON UPDATE CASCADE,
[RoleID] INT NOT NULL
REFERENCES [dbo].[Role] (Id)
ON DELETE CASCADE
ON UPDATE CASCADE,
PRIMARY KEY CLUSTERED ([Id])
);
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question