[dbo].[CMSMDIDCOLUMNSDATA]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	11:13:48 AM Wednesday, March 07, 2007
Last Modified	11:13:51 AM Wednesday, March 07, 2007

	Name	Data Type	Max Length (Bytes)
	UECHECKEDOUT	int	4
	UECHECKEDOUTTIME	datetime	8
$Cluster Primary Key UE107d798c7d7: UEDBID\UEPORINSTANCEID$	UEDBID	int	4
	UEMODTIME	datetime	8
	UENUMEMPTYREQUIRED	int	4
$Cluster Primary Key UE107d798c7d7: UEDBID\UEPORINSTANCEID$	UEPORINSTANCEID	nvarchar(255)	510
	UEPUBSTAGE	int	4
	UEPUBTIME	datetime	8
	UEFIELD0	ntext	max
	UEFIELD1	ntext	max
	UEFIELD10	ntext	max
	UEFIELD11	ntext	max
	UEFIELD12	ntext	max
	UEFIELD13	ntext	max
	UEFIELD14	ntext	max
	UEFIELD15	ntext	max
	UEFIELD16	ntext	max
	UEFIELD17	ntext	max
	UEFIELD18	ntext	max
	UEFIELD19	ntext	max
	UEFIELD2	ntext	max
	UEFIELD20	ntext	max
	UEFIELD21	ntext	max
	UEFIELD22	ntext	max
	UEFIELD23	ntext	max
	UEFIELD24	ntext	max
	UEFIELD25	ntext	max
	UEFIELD26	ntext	max
	UEFIELD27	ntext	max
	UEFIELD28	ntext	max
	UEFIELD29	ntext	max
	UEFIELD3	ntext	max
	UEFIELD30	ntext	max
	UEFIELD31	ntext	max
	UEFIELD32	ntext	max
	UEFIELD33	ntext	max
	UEFIELD34	ntext	max
	UEFIELD35	ntext	max
	UEFIELD36	ntext	max
	UEFIELD37	ntext	max
	UEFIELD38	ntext	max
	UEFIELD39	ntext	max
	UEFIELD4	ntext	max
	UEFIELD40	ntext	max
	UEFIELD41	ntext	max
	UEFIELD42	ntext	max
	UEFIELD43	ntext	max
	UEFIELD44	ntext	max
	UEFIELD45	ntext	max
	UEFIELD46	ntext	max
	UEFIELD47	ntext	max
	UEFIELD48	ntext	max
	UEFIELD49	ntext	max
	UEFIELD5	ntext	max
	UEFIELD50	ntext	max
	UEFIELD51	ntext	max
	UEFIELD52	ntext	max
	UEFIELD53	ntext	max
	UEFIELD54	ntext	max
	UEFIELD55	ntext	max
	UEFIELD56	ntext	max
	UEFIELD57	ntext	max
	UEFIELD58	ntext	max
	UEFIELD59	ntext	max
	UEFIELD6	ntext	max
	UEFIELD60	ntext	max
	UEFIELD61	ntext	max
	UEFIELD62	ntext	max
	UEFIELD63	ntext	max
	UEFIELD64	ntext	max
	UEFIELD65	ntext	max
	UEFIELD66	ntext	max
	UEFIELD67	ntext	max
	UEFIELD68	ntext	max
	UEFIELD69	ntext	max
	UEFIELD7	ntext	max
	UEFIELD8	ntext	max
	UEFIELD9	ntext	max

	Name	Columns	Unique
$Cluster Primary Key UE107d798c7d7: UEDBID\UEPORINSTANCEID$	UE107d798c7d7	UEDBID, UEPORINSTANCEID

Type	Action	Owning Principal
Grant	Delete	portaldba_group
Grant	Insert	portaldba_group
Grant	Select	portaldba_group
Grant	Update	portaldba_group

SQL Script

CREATE TABLE [dbo].[CMSMDIDCOLUMNSDATA]
(
[UECHECKEDOUT] [int] NULL,
[UECHECKEDOUTTIME] [datetime] NULL,
[UEDBID] [int] NOT NULL,
[UEMODTIME] [datetime] NULL,
[UENUMEMPTYREQUIRED] [int] NULL,
[UEPORINSTANCEID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UEPUBSTAGE] [int] NULL,
[UEPUBTIME] [datetime] NULL,
[UEFIELD0] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD1] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD10] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD11] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD12] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD13] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD14] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD15] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD16] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD17] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD18] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD19] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD2] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD20] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD21] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD22] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD23] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD24] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD25] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD26] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD27] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD28] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD29] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD3] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD30] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD31] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD32] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD33] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD34] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD35] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD36] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD37] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD38] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD39] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD4] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD40] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD41] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD42] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD43] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD44] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD45] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD46] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD47] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD48] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD49] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD5] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD50] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD51] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD52] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD53] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD54] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD55] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD56] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD57] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD58] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD59] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD6] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD60] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD61] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD62] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD63] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD64] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD65] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD66] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD67] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD68] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD69] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD7] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD8] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UEFIELD9] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[CMSMDIDCOLUMNSDATA] ADD CONSTRAINT [UE107d798c7d7] PRIMARY KEY CLUSTERED ([UEDBID], [UEPORINSTANCEID]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[CMSMDIDCOLUMNSDATA] TO [portaldba_group]
GRANT INSERT ON  [dbo].[CMSMDIDCOLUMNSDATA] TO [portaldba_group]
GRANT DELETE ON  [dbo].[CMSMDIDCOLUMNSDATA] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[CMSMDIDCOLUMNSDATA] TO [portaldba_group]
GO