Tables [dbo].[al_meta_binary_store]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count2
Created10:33:06 PM Thursday, February 10, 2011
Last Modified10:33:06 PM Thursday, February 10, 2011
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
role_idint4
No
lib_fileimagemax
No
assembly_namenvarchar(255)510
No
assembly_versionnvarchar(1000)2000
No
creation_usernvarchar(64)128
Yes
creation_dateint4
Yes
last_update_usernvarchar(64)128
Yes
last_update_dateint4
Yes
version_numberint4
Yes
('0 ')
service_urlnvarchar(1000)2000
No
inactiveint4
Yes
('0 ')
checksumnvarchar(2000)4000
Yes
url_registeredint4
Yes
('0 ')
api_docxmlmax
Yes
SQL Script
CREATE TABLE [dbo].[al_meta_binary_store]
(
[role_id] [int] NOT NULL,
[lib_file] [image] NOT NULL,
[assembly_name] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[assembly_version] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[creation_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[creation_date] [int] NULL,
[last_update_user] [nvarchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__AL_META_BIN_VER] DEFAULT ('0 '),
[service_url] [nvarchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[inactive] [int] NULL CONSTRAINT [DF__AL_META_BIN_INACT] DEFAULT ('0 '),
[checksum] [nvarchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[url_registered] [int] NULL CONSTRAINT [DF__AL_META_BIN_URL_REG] DEFAULT ('0 '),
[api_doc] [xml] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
Uses
Used By