Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
SysSystemInformation Table
Collapse All Expand All
iVend Database Database : SysSystemInformation Table |
Description
System table. Do not modify
Properties
Creation Date |
12/26/2018 4:05 PM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
1 |
Data Space Used |
8.00 KB |
Index Space Used |
8.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
|
InformationKey |
Primary Key of the record |
VarWChar |
50 |
|
|
|
|
Information1 |
Information 1 |
VarWChar |
100 |
|
|
|
|
Information2 |
Information 2 |
VarWChar |
100 |
|
|
|
|
Information3 |
Information 3 |
VarWChar |
4000 |
|
|
|
|
Information4 |
Information 4 |
VarWChar |
100 |
|
|
|
|
Information5 |
Information 5 |
VarWChar |
100 |
|
|
|
|
Information6 |
Information6 |
VarWChar |
100 |
|
|
|
|
Information7 |
Information7 |
VarWChar |
100 |
|
|
|
|
Information8 |
Information8 |
VarWChar |
100 |
|
|
|
|
Information9 |
Information9 |
VarWChar |
100 |
|
|
|
|
Information10 |
Information10 |
VarWChar |
100 |
|
|
|
|
Information11 |
Information11 |
VarWChar |
100 |
|
|
|
|
Information12 |
Information12 |
VarWChar |
100 |
|
|
|
|
Information13 |
Information13 |
VarWChar |
100 |
|
|
|
|
Information14 |
System table column. Do not modify. |
VarWChar |
100 |
|
|
|
|
Information15 |
System table column. Do not modify. |
VarWChar |
100 |
|
|
|
|
Information16 |
System table column. Do not modify. |
VarWChar |
100 |
|
|
|
|
Information17 |
System table column. Do not modify. |
VarWChar |
100 |
|
|
|
|
Information18 |
System table column. Do not modify. |
VarWChar |
100 |
|
|
|
|
Information19 |
System table column. Do not modify. |
VarWChar |
100 |
|
|
|
|
Information20 |
System Column. Do not Modify |
VarWChar |
100 |
|
|
|
|
Information21 |
System Column. Do not Modify |
VarWChar |
100 |
|
|
|
|
Information22 |
System Column. Do not Modify |
VarWChar |
100 |
|
|
|
|
Information23 |
System Column. Do not Modify |
VarWChar |
100 |
|
|
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[SysSystemInformation]( [InformationKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Information1] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information2] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information3] [nvarchar](4000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information4] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information5] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information6] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information7] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information8] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information9] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information10] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information11] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information12] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information13] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information14] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information15] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information16] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information17] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information18] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information19] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information20] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information21] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information22] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Information23] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, CONSTRAINT [PK_SysSystemInformation] PRIMARY KEY CLUSTERED ( [InformationKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.