Tables [dbo].[PlayWaveformAlertSVC]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created11:43:57 AM Friday, March 26, 2010
Last Modified11:43:57 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK__PlayWaveformAler__0A9D95DB: RefIDRefIDvarchar(255)255
No
('')
RepeatCountint4
Yes
Wavefilevarchar(255)255
Yes
('')
IsLooptinyint1
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__PlayWaveformAler__0A9D95DB: RefIDPK__PlayWaveformAler__0A9D95DBRefID
Yes
SQL Script
CREATE TABLE [dbo].[PlayWaveformAlertSVC]
(
[RefID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF__PlayWavef__RefID__08B54D69] DEFAULT (''),
[RepeatCount] [int] NULL,
[Wavefile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__PlayWavef__Wavef__09A971A2] DEFAULT (''),
[IsLoop] [tinyint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlayWaveformAlertSVC] ADD CONSTRAINT [PK__PlayWaveformAler__0A9D95DB] PRIMARY KEY CLUSTERED ([RefID]) ON [PRIMARY]
GO
Uses