Tables [dbo].[UserDRServerJoin]
(local) > SupportBridge > Tables > dbo.UserDRServerJoin
Properties
PropertyValue
Row Count0
Created12:44:47 PM Thursday, October 04, 2007
Last Modified12:44:47 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK__UserDRServerJoin__5C02A283: userIDForeign Keys FK__UserDRSer__userI__5CF6C6BC: [dbo].[Users].userIDuserIDint4
No
Foreign Keys FK__UserDRSer__drSer__5DEAEAF5: [dbo].[DataRoutingServers].drServerIDdrServerIDint4
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__UserDRServerJoin__5C02A283: userIDPK__UserDRServerJoin__5C02A283userID
Yes
Foreign Keys Foreign Keys
NameColumns
FK__UserDRSer__drSer__5DEAEAF5drServerID->[dbo].[DataRoutingServers].[drServerID]
FK__UserDRSer__userI__5CF6C6BCuserID->[dbo].[Users].[userID]
SQL Script
CREATE TABLE [dbo].[UserDRServerJoin]
(
[userID] [int] NOT NULL,
[drServerID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserDRServerJoin] ADD CONSTRAINT [PK__UserDRServerJoin__5C02A283] PRIMARY KEY CLUSTERED ([userID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UserDRServerJoin] ADD CONSTRAINT [FK__UserDRSer__drSer__5DEAEAF5] FOREIGN KEY ([drServerID]) REFERENCES [dbo].[DataRoutingServers] ([drServerID])
GO
ALTER TABLE [dbo].[UserDRServerJoin] ADD CONSTRAINT [FK__UserDRSer__userI__5CF6C6BC] FOREIGN KEY ([userID]) REFERENCES [dbo].[Users] ([userID])
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved