Tables [dbo].[wsm_task_schedule]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:46 AM Wednesday, March 07, 2007
Last Modified11:10:02 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKwsm_task_schedule: task_sched_idtask_sched_idint4
No
start_yearint4
Yes
start_monthint4
Yes
start_date_of_monthnvarchar(255)510
Yes
start_hourint4
Yes
start_minuteint4
Yes
start_secondint4
Yes
isrepeatint4
Yes
repeat_intervalint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKwsm_task_schedule: task_sched_idXPKwsm_task_scheduletask_sched_id
Yes
Permissions
TypeActionOwning Principal
GrantDeletewsm_admin_group
GrantInsertwsm_admin_group
GrantSelectwsm_admin_group
GrantUpdatewsm_admin_group
GrantSelectwsm_ro_group
SQL Script
CREATE TABLE [dbo].[wsm_task_schedule]
(
[task_sched_id] [int] NOT NULL,
[start_year] [int] NULL,
[start_month] [int] NULL,
[start_date_of_month] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[start_hour] [int] NULL,
[start_minute] [int] NULL,
[start_second] [int] NULL,
[isrepeat] [int] NULL,
[repeat_interval] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[wsm_task_schedule] ADD CONSTRAINT [XPKwsm_task_schedule] PRIMARY KEY CLUSTERED ([task_sched_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[wsm_task_schedule] TO [wsm_admin_group]
GRANT INSERT ON  [dbo].[wsm_task_schedule] TO [wsm_admin_group]
GRANT DELETE ON  [dbo].[wsm_task_schedule] TO [wsm_admin_group]
GRANT UPDATE ON  [dbo].[wsm_task_schedule] TO [wsm_admin_group]
GRANT SELECT ON  [dbo].[wsm_task_schedule] TO [wsm_ro_group]
GO
Uses
Used By