Tables [dbo].[Fields]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count20
Created12:44:45 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key pk_fields: fieldIDfieldIDint4
No
1 - 1
fieldTypeint4
No
divisionIDint4
No
fieldNamenvarchar(50)100
No
fieldOrderint4
No
mandatoryint4
No
activeint4
No
displayNamenvarchar(150)300
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_fields: fieldIDpk_fieldsfieldID
Yes
SQL Script
CREATE TABLE [dbo].[Fields]
(
[fieldID] [int] NOT NULL IDENTITY(1, 1),
[fieldType] [int] NOT NULL,
[divisionID] [int] NOT NULL,
[fieldName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fieldOrder] [int] NOT NULL,
[mandatory] [int] NOT NULL,
[active] [int] NOT NULL,
[displayName] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Fields] ADD CONSTRAINT [pk_fields] PRIMARY KEY CLUSTERED ([fieldID]) ON [PRIMARY]
GO
Uses
Used By