Tables [dbo].[monappstatetable]
(local) > itpam > Tables > dbo.monappstatetable
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count0
Created11:42:02 AM Friday, March 26, 2010
Last Modified11:42:02 AM Friday, March 26, 2010
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_monappstatetable_ID: IDIDint4
No
1 - 1
Statusvarchar(45)45
Yes
('NORMAL')
MonStateXMLtextmax
Yes
ApplicationPathvarchar(255)255
Yes
ActivatedOndatetime8
Yes
ActivatedByvarchar(255)255
Yes
compressedStatetinyint1
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_monappstatetable_ID: IDPK_monappstatetable_IDID
Yes
SQL Script
CREATE TABLE [dbo].[monappstatetable]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[Status] [varchar] (45) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__monappsta__Statu__30F848ED] DEFAULT ('NORMAL'),
[MonStateXML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ApplicationPath] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ActivatedOn] [datetime] NULL,
[ActivatedBy] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[compressedState] [tinyint] NOT NULL CONSTRAINT [DF__monappsta__compr__31EC6D26] DEFAULT ((0))
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[monappstatetable] ADD CONSTRAINT [PK_monappstatetable_ID] PRIMARY KEY CLUSTERED ([ID]) ON [PRIMARY]
GO
Uses
Created 03 June 2010 08:02
Copyright 2010 by CA Technologies, Inc. - All Rights Reserved