Table Icon dbo.UserRoles

Table Properties

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

Columns

  Name Description Data Type Length NULL Default RowGUIDCOL Computed
  RoleName nvarchar 256      
  Description nvarchar 512      

Total: 2 column(s)

Indentity Column

No identity column exists

Check Constraints

No check constraints exists

Indexes

Index Primary Unique Clustered
IX_UserRoles   Unique Index  

Permissions

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

SQL

CREATE TABLE [UserRoles] (
	[RoleName] [nvarchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Description] [nvarchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	CONSTRAINT [IX_UserRoles] UNIQUE  NONCLUSTERED 
	(
		[RoleName]
	)  ON [PRIMARY] 
) ON [PRIMARY]
GO



					

Generated on 26/08/2004 15:05:23 by DataAide.