Tables [dbo].[uejm_adapter]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:37 AM Wednesday, March 07, 2007
Last Modified11:09:13 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key XPKuejm_adapter: name\server\instance\modified\type\int_typenamenvarchar(255)510
No
Cluster Primary Key XPKuejm_adapter: name\server\instance\modified\type\int_typeservernvarchar(255)510
No
Cluster Primary Key XPKuejm_adapter: name\server\instance\modified\type\int_typeinstancenvarchar(128)256
No
Cluster Primary Key XPKuejm_adapter: name\server\instance\modified\type\int_typetypenvarchar(128)256
No
Cluster Primary Key XPKuejm_adapter: name\server\instance\modified\type\int_typeint_typeint4
No
Cluster Primary Key XPKuejm_adapter: name\server\instance\modified\type\int_typemodifieddecimal(18,0)9
No
uejm1nvarchar(255)510
Yes
uejm2nvarchar(255)510
Yes
uejm3nvarchar(255)510
Yes
uejm4nvarchar(255)510
Yes
uejm5nvarchar(255)510
Yes
dataimagemax
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key XPKuejm_adapter: name\server\instance\modified\type\int_typeXPKuejm_adaptername, server, instance, modified, type, int_type
Yes
SQL Script
CREATE TABLE [dbo].[uejm_adapter]
(
[name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[server] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[instance] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[type] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[int_type] [int] NOT NULL,
[modified] [decimal] (18, 0) NOT NULL,
[uejm1] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uejm2] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uejm3] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uejm4] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[uejm5] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[data] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[uejm_adapter] ADD CONSTRAINT [XPKuejm_adapter] PRIMARY KEY CLUSTERED ([name], [server], [instance], [modified], [type], [int_type]) ON [PRIMARY]
GO
Uses