Advertisement
Guest User

Untitled

a guest
Dec 9th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. CREATE TABLE [dbo].[Users] (
  2. [Id] INT IDENTITY (1, 1) NOT NULL,
  3. [Email] NVARCHAR (MAX) NULL,
  4. [Password] NVARCHAR (MAX) NULL,
  5. [RoleId] INT NOT NULL,
  6. CONSTRAINT [PK_dbo.Users] PRIMARY KEY CLUSTERED ([Id] ASC),
  7. CONSTRAINT [FK_dbo.Users_dbo.Roles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Roles] ([Id]) ON DELETE CASCADE
  8. );
  9.  
  10.  
  11. GO
  12. CREATE NONCLUSTERED INDEX [IX_RoleId]
  13. ON [dbo].[Users]([RoleId] ASC);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement