Tables [dbo].[TASKACCESSCONTROL]
(local) > itpam > Tables > dbo.TASKACCESSCONTROL
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created11:42:02 AM Friday, March 26, 2010
Last Modified11:42:02 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
ROIDint4
Yes
PERMISSIONvarchar(255)255
Yes
ISUSERtinyint1
Yes
Cluster Primary Key PK_TASKACCESSCONTROL_PERMISSIONID: PERMISSIONIDPERMISSIONIDint4
No
1 - 1
IDENTITYVALUEvarchar(50)50
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_TASKACCESSCONTROL_PERMISSIONID: PERMISSIONIDPK_TASKACCESSCONTROL_PERMISSIONIDPERMISSIONID
Yes
SQL Script
CREATE TABLE [dbo].[TASKACCESSCONTROL]
(
[ROID] [int] NULL,
[PERMISSION] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISUSER] [tinyint] NULL,
[PERMISSIONID] [int] NOT NULL IDENTITY(1, 1),
[IDENTITYVALUE] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TASKACCESSCONTROL] ADD CONSTRAINT [PK_TASKACCESSCONTROL_PERMISSIONID] PRIMARY KEY CLUSTERED ([PERMISSIONID]) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved