Tables [dbo].[VanlineGroup]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)5
Created9:11:33 AM Thursday, May 23, 2024
Last Modified9:11:39 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_VanlineGroup: VanlineGroupIDVanlineGroupIDint4
No
1 - 1
Indexes IX_VanlineGroup_VanlineGroupName: VanlineGroupNameVanlineGroupNamevarchar(64)64
No
Indexes IX_VanlineGroup_VanlineExternalCode: VanlineExternalCodeVanlineExternalCodevarchar(10)10
No
Foreign Keys FK_VanlineGroup_XmlSystemDataTypeMap: [dbo].[XmlSystemDataTypeMap].XmlSystemDataTypeMapFIDIndexes IX_VanlineGroup_XmlSystemDataTypeMapFID: XmlSystemDataTypeMapFIDXmlSystemDataTypeMapFIDint4
Yes
InactivateItemCodeMappingsbit1
No
((0))
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_VanlineGroup: VanlineGroupIDPK_VanlineGroupVanlineGroupID
Yes
IX_VanlineGroup_VanlineExternalCodeVanlineExternalCode
Yes
IX_VanlineGroup_VanlineGroupNameVanlineGroupName
Yes
IX_VanlineGroup_XmlSystemDataTypeMapFIDXmlSystemDataTypeMapFID
Foreign Keys Foreign Keys
NameColumns
FK_VanlineGroup_XmlSystemDataTypeMapXmlSystemDataTypeMapFID->[dbo].[XmlSystemDataTypeMap].[XmlSystemDataTypeMapID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[VanlineGroup]
(
[VanlineGroupID] [int] NOT NULL IDENTITY(1, 1),
[VanlineGroupName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[VanlineExternalCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[XmlSystemDataTypeMapFID] [int] NULL,
[InactivateItemCodeMappings] [bit] NOT NULL CONSTRAINT [DF_VanlineGroup_InactivateItemCodeMappings] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineGroup] ADD CONSTRAINT [PK_VanlineGroup] PRIMARY KEY CLUSTERED  ([VanlineGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineGroup] ADD CONSTRAINT [IX_VanlineGroup_VanlineExternalCode] UNIQUE NONCLUSTERED  ([VanlineExternalCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineGroup] ADD CONSTRAINT [IX_VanlineGroup_VanlineGroupName] UNIQUE NONCLUSTERED  ([VanlineGroupName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_VanlineGroup_XmlSystemDataTypeMapFID] ON [dbo].[VanlineGroup] ([XmlSystemDataTypeMapFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[VanlineGroup] ADD CONSTRAINT [FK_VanlineGroup_XmlSystemDataTypeMap] FOREIGN KEY ([XmlSystemDataTypeMapFID]) REFERENCES [dbo].[XmlSystemDataTypeMap] ([XmlSystemDataTypeMapID])
GO
GRANT SELECT ON  [dbo].[VanlineGroup] TO [MssExec]
GRANT INSERT ON  [dbo].[VanlineGroup] TO [MssExec]
GRANT DELETE ON  [dbo].[VanlineGroup] TO [MssExec]
GRANT UPDATE ON  [dbo].[VanlineGroup] TO [MssExec]
GO
Uses
Used By