[dbo].[entity

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	1:22:02 AM Thursday, September 10, 2009
Last Modified	1:22:02 AM Thursday, September 10, 2009

Property

Value

Collation

SQL_Latin1_General_CP1_CI_AS

Row Count

Created

1:22:02 AM Thursday, September 10, 2009

Last Modified

1:22:02 AM Thursday, September 10, 2009

Name	Data Type	Max Length (Bytes)
c_USMID	varchar(64)	64
c__modifiedDate	bigint	8
anyXML	text	max
c_asbo_cmdb_id	varchar(255)	255
c_asbo_nsm_id	varchar(255)	255
c_asbo_spectrum_id	varchar(255)	255
c_usm_class_name	varchar(255)	255

Name

Data Type

Max Length (Bytes)

Allow Nulls

c_USMID

varchar(64)

c__modifiedDate

bigint

anyXML

text

max

c_asbo_cmdb_id

varchar(255)

255

c_asbo_nsm_id

varchar(255)

255

c_asbo_spectrum_id

varchar(255)

255

c_usm_class_name

varchar(255)

255

	Name	Columns	Unique
	PK__entity_t__5EBF139D	c_USMID

Name

Columns

Unique

PK__entity_t__5EBF139D

c_USMID

SQL Script

CREATE TABLE [dbo].[entity_t]
(
[c_USMID] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[c__modifiedDate] [bigint] NULL,
[anyXML] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_asbo_cmdb_id] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_asbo_nsm_id] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_asbo_spectrum_id] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[c_usm_class_name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[entity_t] ADD CONSTRAINT [PK__entity_t__5EBF139D] PRIMARY KEY CLUSTERED ([c_USMID]) ON [PRIMARY]
GO