[dbo].[nctngref]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:07:23 AM Wednesday, March 07, 2007
Last Modified	11:09:40 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key XPKnctngref: unitid\domainid$	domainid	int	4
$Cluster Primary Key XPKnctngref: unitid\domainid$	unitid	int	4
	unittype	int	4
	search1	varchar(64)	64
	search2	varchar(64)	64
	search3	varchar(64)	64
	search4	int	4
	clsname	varchar(64)	64
	uuid	varchar(64)	64

	Name	Columns	Unique
$Cluster Primary Key XPKnctngref: unitid\domainid$	XPKnctngref	unitid, domainid
	nctngref_sk1	uuid

Type	Action	Owning Principal
Grant	Delete	ca_itrm_group
Grant	Insert	ca_itrm_group
Grant	Select	ca_itrm_group
Grant	Update	ca_itrm_group
Grant	Select	upmuser_group
Grant	Select	ca_itrm_group_ams
Grant	Select	ams_group

SQL Script

CREATE TABLE [dbo].[nctngref]
(
[domainid] [int] NOT NULL,
[unitid] [int] NOT NULL,
[unittype] [int] NULL,
[search1] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[search2] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[search3] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[search4] [int] NULL,
[clsname] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uuid] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[nctngref] ADD CONSTRAINT [XPKnctngref] PRIMARY KEY CLUSTERED ([unitid], [domainid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [nctngref_sk1] ON [dbo].[nctngref] ([uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[nctngref] TO [ams_group]
GRANT SELECT ON  [dbo].[nctngref] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[nctngref] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[nctngref] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[nctngref] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[nctngref] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[nctngref] TO [upmuser_group]
GO