Tables [dbo].[usm_dst]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count9
Created11:07:43 AM Wednesday, March 07, 2007
Last Modified11:09:47 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key XPKusm_dst: dst_iddst_idvarchar(64)64
No
in_useint4
Yes
((0))
start_monthint4
Yes
start_dayint4
Yes
start_dayof_weekint4
Yes
start_timeint4
Yes
end_monthint4
Yes
end_dayint4
Yes
end_dayof_weekint4
Yes
end_timeint4
Yes
start_time_modeint4
Yes
end_time_modeint4
Yes
dst_savingsint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKusm_dst: dst_idXPKusm_dstdst_id
Yes
Permissions
TypeActionOwning Principal
GrantDeleteusmgroup
GrantInsertusmgroup
GrantSelectusmgroup
GrantUpdateusmgroup
SQL Script
CREATE TABLE [dbo].[usm_dst]
(
[dst_id] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[in_use] [int] NULL CONSTRAINT [DF__usm_dst__in_use__6B45B16A] DEFAULT ((0)),
[start_month] [int] NULL,
[start_day] [int] NULL,
[start_dayof_week] [int] NULL,
[start_time] [int] NULL,
[end_month] [int] NULL,
[end_day] [int] NULL,
[end_dayof_week] [int] NULL,
[end_time] [int] NULL,
[start_time_mode] [int] NULL,
[end_time_mode] [int] NULL,
[dst_savings] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[usm_dst] ADD CONSTRAINT [XPKusm_dst] PRIMARY KEY CLUSTERED ([dst_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usm_dst] TO [usmgroup]
GRANT INSERT ON  [dbo].[usm_dst] TO [usmgroup]
GRANT DELETE ON  [dbo].[usm_dst] TO [usmgroup]
GRANT UPDATE ON  [dbo].[usm_dst] TO [usmgroup]
GO
Uses