Tables [dbo].[scriptlibs]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count11
Created12:44:46 PM Thursday, October 04, 2007
Last Modified12:44:46 PM Thursday, October 04, 2007
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__scriptlibs__2116E6DF: libIDlibIDint4
No
1 - 1
libNamenvarchar(128)256
No
libLangint4
No
divisionIDint4
No
activeint4
No
((1))
GUIDnvarchar(255)510
Yes
versionint4
No
((1))
isLockedint4
Yes
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK__scriptlibs__2116E6DF: libIDPK__scriptlibs__2116E6DFlibID
Yes
SQL Script
CREATE TABLE [dbo].[scriptlibs]
(
[libID] [int] NOT NULL IDENTITY(1, 1),
[libName] [nvarchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[libLang] [int] NOT NULL,
[divisionID] [int] NOT NULL,
[active] [int] NOT NULL CONSTRAINT [DF__scriptlib__activ__220B0B18] DEFAULT ((1)),
[GUID] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[version] [int] NOT NULL CONSTRAINT [DF__scriptlib__versi__22FF2F51] DEFAULT ((1)),
[isLocked] [int] NULL CONSTRAINT [DF__scriptlib__isLoc__23F3538A] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[scriptlibs] ADD CONSTRAINT [PK__scriptlibs__2116E6DF] PRIMARY KEY CLUSTERED ([libID]) ON [PRIMARY]
GO
Uses
Used By