Tables [dbo].[LibFunctions]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count54
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentity
libIDint4
No
Cluster Primary Key PK__LibFunctions__25DB9BFC: functionIDfunctionIDint4
No
1 - 1
functionNamenvarchar(128)256
No
libFunctionntextmax
No
funcDescnvarchar(1024)2048
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__LibFunctions__25DB9BFC: functionIDPK__LibFunctions__25DB9BFCfunctionID
Yes
SQL Script
CREATE TABLE [dbo].[LibFunctions]
(
[libID] [int] NOT NULL,
[functionID] [int] NOT NULL IDENTITY(1, 1),
[functionName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[libFunction] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[funcDesc] [nvarchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[LibFunctions] ADD CONSTRAINT [PK__LibFunctions__25DB9BFC] PRIMARY KEY CLUSTERED ([functionID]) ON [PRIMARY]
GO
Uses
Used By