Tables [dbo].[buslrel]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created11:07:04 AM Wednesday, March 07, 2007
Last Modified11:09:34 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKbuslrel: ididint4
No
Indexes buslrel_x0: l_persid\l_attrl_persidnvarchar(60)120
Yes
Indexes buslrel_x0: l_persid\l_attrl_attrnvarchar(30)60
Yes
l_sqlint4
Yes
Indexes buslrel_x1: r_persid\r_attrr_persidnvarchar(60)120
Yes
Indexes buslrel_x1: r_persid\r_attrr_attrnvarchar(30)60
Yes
r_sqlint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKbuslrel: idXPKbuslrelid
Yes
buslrel_x0l_persid, l_attr
buslrel_x1r_persid, r_attr
Permissions
TypeActionOwning Principal
GrantDeleteservice_desk_admin_group
GrantInsertservice_desk_admin_group
GrantSelectservice_desk_admin_group
GrantUpdateservice_desk_admin_group
GrantSelectservice_desk_ro_group
SQL Script
CREATE TABLE [dbo].[buslrel]
(
[id] [int] NOT NULL,
[l_persid] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[l_attr] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[l_sql] [int] NULL,
[r_persid] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[r_attr] [nvarchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[r_sql] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[buslrel] ADD CONSTRAINT [XPKbuslrel] PRIMARY KEY CLUSTERED ([id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [buslrel_x0] ON [dbo].[buslrel] ([l_persid], [l_attr]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [buslrel_x1] ON [dbo].[buslrel] ([r_persid], [r_attr]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[buslrel] TO [service_desk_admin_group]
GRANT INSERT ON  [dbo].[buslrel] TO [service_desk_admin_group]
GRANT DELETE ON  [dbo].[buslrel] TO [service_desk_admin_group]
GRANT UPDATE ON  [dbo].[buslrel] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[buslrel] TO [service_desk_ro_group]
GO
Uses