[dbo].[ujo_ext_calendar]

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Row Count	0
Created	11:13:12 AM Wednesday, March 07, 2007
Last Modified	11:13:12 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
name	varchar(30)	30
cal_id	int	4
as_work	char(7)	7
as_holcal	varchar(30)	30
as_cyccal	varchar(30)	30
as_hact	char(1)	1
as_nwact	char(1)	1
as_adj	int	4
as_datecon	varchar(255)	255

	Name	Columns	Unique
	ext_calendar_PUC	name

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

SQL Script

CREATE TABLE [dbo].[ujo_ext_calendar]
(
[name] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[cal_id] [int] NOT NULL,
[as_work] [char] (7) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_holcal] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_cyccal] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_hact] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_nwact] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[as_adj] [int] NULL,
[as_datecon] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE CLUSTERED INDEX [ext_calendar_PUC] ON [dbo].[ujo_ext_calendar] ([name]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[ujo_ext_calendar] TO [ujoadmin]
GRANT INSERT ON  [dbo].[ujo_ext_calendar] TO [ujoadmin]
GRANT DELETE ON  [dbo].[ujo_ext_calendar] TO [ujoadmin]
GRANT UPDATE ON  [dbo].[ujo_ext_calendar] TO [ujoadmin]
GO