Table Properties

Name	Value
Owner	dbo
Created	2004-05-31
Located On	PRIMARY
Rows	2
Data Size KB	8
Index Size KB	40

Columns

	Name	Description	Data Type	Length	NULL	Default	RowGUIDCOL	Computed
	Username		nvarchar	50
	Rolename		nvarchar	256

Total: 2 column(s)

Indentity Column

No identity column exists

Check Constraints

No check constraints exists

Indexes

Index	Primary	Unique	Clustered
IX_UsersInRoles
IX_UsersInRoles_1

Permissions

No direct permissions defined (N.B. Permissions may be inherited from roles

SQL

CREATE TABLE [UsersInRoles] (
	[Username] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Rolename] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	CONSTRAINT [FK_UsersInRoles_UserRoles] FOREIGN KEY 
	(
		[Rolename]
	) REFERENCES [UserRoles] (
		[RoleName]
	),
	CONSTRAINT [FK_UsersInRoles_Users] FOREIGN KEY 
	(
		[Username]
	) REFERENCES [Users] (
		[UserName]
	)
) ON [PRIMARY]
GO