Tables [dbo].[HealingEnumValues]
(local) > SupportBridge > Tables > dbo.HealingEnumValues
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count78
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys FK__HealingEn__enumI__5F141958: [dbo].[MonitorEnums].enumIDenumIDint4
No
enumValuenvarchar(200)400
No
enumLabelnvarchar(200)400
No
Foreign Keys Foreign Keys
NameColumns
FK__HealingEn__enumI__5F141958enumID->[dbo].[MonitorEnums].[enumID]
SQL Script
CREATE TABLE [dbo].[HealingEnumValues]
(
[enumID] [int] NOT NULL,
[enumValue] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[enumLabel] [nvarchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[HealingEnumValues] ADD CONSTRAINT [FK__HealingEn__enumI__5F141958] FOREIGN KEY ([enumID]) REFERENCES [dbo].[MonitorEnums] ([enumID])
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved