Tables [dbo].[pd_time]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:24 AM Wednesday, March 07, 2007
Last Modified11:09:41 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Primary Key pd_time_pk: time_idtime_idint4
No
Indexes $pd_ti_u0000148a00000000: time_valuetime_valuenvarchar(5)10
No
Indexes Indexes
NameColumnsUnique
Primary Key pd_time_pk: time_idpd_time_pktime_id
Yes
$pd_ti_u0000148a00000000time_value
Yes
Permissions
TypeActionOwning Principal
GrantDeletepdadmin
GrantInsertpdadmin
GrantDeleteuniadmin
GrantInsertuniadmin
GrantSelectpdadmin
GrantUpdatepdadmin
GrantSelectpduser
GrantSelectuniadmin
GrantUpdateuniadmin
SQL Script
CREATE TABLE [dbo].[pd_time]
(
[time_id] [int] NOT NULL,
[time_value] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[pd_time] ADD CONSTRAINT [pd_time_pk] PRIMARY KEY NONCLUSTERED ([time_id]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$pd_ti_u0000148a00000000] ON [dbo].[pd_time] ([time_value]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[pd_time] TO [pdadmin]
GRANT INSERT ON  [dbo].[pd_time] TO [pdadmin]
GRANT DELETE ON  [dbo].[pd_time] TO [pdadmin]
GRANT UPDATE ON  [dbo].[pd_time] TO [pdadmin]
GRANT SELECT ON  [dbo].[pd_time] TO [pduser]
GRANT SELECT ON  [dbo].[pd_time] TO [uniadmin]
GRANT INSERT ON  [dbo].[pd_time] TO [uniadmin]
GRANT DELETE ON  [dbo].[pd_time] TO [uniadmin]
GRANT UPDATE ON  [dbo].[pd_time] TO [uniadmin]
GO
Uses