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 |
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