Tables [dbo].[MonitorEnums]
(local) > SupportBridge > Tables > dbo.MonitorEnums
Properties
PropertyValue
Row Count10
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__MonitorEnums__595B4002: enumIDenumIDint4
No
1 - 1
Foreign Keys FK__MonitorEn__monit__5A4F643B: [dbo].[Monitors].monitorIDmonitorIDint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__MonitorEnums__595B4002: enumIDPK__MonitorEnums__595B4002enumID
Yes
Foreign Keys Foreign Keys
NameColumns
FK__MonitorEn__monit__5A4F643BmonitorID->[dbo].[Monitors].[monitorID]
SQL Script
CREATE TABLE [dbo].[MonitorEnums]
(
[enumID] [int] NOT NULL IDENTITY(1, 1),
[monitorID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MonitorEnums] ADD CONSTRAINT [PK__MonitorEnums__595B4002] PRIMARY KEY CLUSTERED ([enumID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[MonitorEnums] ADD CONSTRAINT [FK__MonitorEn__monit__5A4F643B] FOREIGN KEY ([monitorID]) REFERENCES [dbo].[Monitors] ([monitorID])
GO
Uses
Used By
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved