Tables [dbo].[datasource]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
HeapYes
Row Count0
Created11:07:11 AM Wednesday, March 07, 2007
Last Modified11:09:36 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
idint4
Yes
sequencetinyint1
Yes
templatetinyint1
Yes
Indexes $datas_u0000354700000000: screennamescreennamevarchar(32)32
No
pluginvarchar(32)32
Yes
descriptionvarchar(32)32
Yes
priorityint4
Yes
configvarchar(1950)1950
Yes
Indexes Indexes
NameColumnsUnique
$datas_u0000354700000000screenname
Yes
SQL Script
CREATE TABLE [dbo].[datasource]
(
[id] [int] NULL,
[sequence] [tinyint] NULL,
[template] [tinyint] NULL,
[screenname] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[plugin] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[priority] [int] NULL,
[config] [varchar] (1950) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$datas_u0000354700000000] ON [dbo].[datasource] ([screenname]) ON [PRIMARY]
GO
Uses
Used By