Tables [dbo].[XmlSystemDataTypeMap]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)20
Created10:32:30 AM Thursday, July 8, 2010
Last Modified7:43:44 PM Wednesday, February 28, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefaultDescription
Cluster Primary Key PK_XmlSystemDataTypeMap: XmlSystemDataTypeMapIDXmlSystemDataTypeMapIDint4
No
1 - 1The primary key.
Foreign Keys FK_XmlSystemDataTypeMap_XmlSystem: [dbo].[XmlSystem].XmlSystemFIDXmlSystemFIDint4
No
The XmlSystem foreign key.
Foreign Keys FK_XmlSystemDataTypeMap_XmlSystemDataType: [dbo].[XmlSystemDataType].XmlSystemDataTypeFIDXmlSystemDataTypeFIDint4
No
The XmlSystemDataType foreign key.
Indexes IX_XmlSystemDataTypeMap_Name: NameNamevarchar(64)64
No
The name of the system data type mapping.
ClearPreviousXmlErrorsbit1
No
((0))Determines if all previous errors for this data type are cleared or not when processing this data type.
Indexes Indexes
NameColumnsUniqueFill Factor
Cluster Primary Key PK_XmlSystemDataTypeMap: XmlSystemDataTypeMapIDPK_XmlSystemDataTypeMapXmlSystemDataTypeMapID
Yes
80
IX_XmlSystemDataTypeMap_NameName
Yes
80
Foreign Keys Foreign Keys
NameDeleteColumns
FK_XmlSystemDataTypeMap_XmlSystemDataTypeXmlSystemDataTypeFID->[dbo].[XmlSystemDataType].[XmlSystemDataTypeID]
FK_XmlSystemDataTypeMap_XmlSystemCascadeXmlSystemFID->[dbo].[XmlSystem].[XmlSystemID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
Extended Properties
NameValue
DescriptionMaps the type of data a given XmlSystem deals with.
SQL Script
CREATE TABLE [dbo].[XmlSystemDataTypeMap]
(
[XmlSystemDataTypeMapID] [int] NOT NULL IDENTITY(1, 1),
[XmlSystemFID] [int] NOT NULL,
[XmlSystemDataTypeFID] [int] NOT NULL,
[Name] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ClearPreviousXmlErrors] [bit] NOT NULL CONSTRAINT [DF_XmlSystemDataTypeMap_ClearPreviousXmlErrors] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlSystemDataTypeMap] ADD CONSTRAINT [PK_XmlSystemDataTypeMap] PRIMARY KEY CLUSTERED  ([XmlSystemDataTypeMapID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlSystemDataTypeMap] ADD CONSTRAINT [IX_XmlSystemDataTypeMap_Name] UNIQUE NONCLUSTERED  ([Name]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XmlSystemDataTypeMap] ADD CONSTRAINT [FK_XmlSystemDataTypeMap_XmlSystemDataType] FOREIGN KEY ([XmlSystemDataTypeFID]) REFERENCES [dbo].[XmlSystemDataType] ([XmlSystemDataTypeID])
GO
ALTER TABLE [dbo].[XmlSystemDataTypeMap] ADD CONSTRAINT [FK_XmlSystemDataTypeMap_XmlSystem] FOREIGN KEY ([XmlSystemFID]) REFERENCES [dbo].[XmlSystem] ([XmlSystemID]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[XmlSystemDataTypeMap] TO [MssExec]
GRANT INSERT ON  [dbo].[XmlSystemDataTypeMap] TO [MssExec]
GRANT DELETE ON  [dbo].[XmlSystemDataTypeMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[XmlSystemDataTypeMap] TO [MssExec]
GO
EXEC sp_addextendedproperty N'Description', N'Maps the type of data a given XmlSystem deals with.', 'SCHEMA', N'dbo', 'TABLE', N'XmlSystemDataTypeMap', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_Description', N'Determines if all previous errors for this data type are cleared or not when processing this data type.', 'SCHEMA', N'dbo', 'TABLE', N'XmlSystemDataTypeMap', 'COLUMN', N'ClearPreviousXmlErrors'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The name of the system data type mapping.', 'SCHEMA', N'dbo', 'TABLE', N'XmlSystemDataTypeMap', 'COLUMN', N'Name'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The XmlSystemDataType foreign key.', 'SCHEMA', N'dbo', 'TABLE', N'XmlSystemDataTypeMap', 'COLUMN', N'XmlSystemDataTypeFID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The primary key.', 'SCHEMA', N'dbo', 'TABLE', N'XmlSystemDataTypeMap', 'COLUMN', N'XmlSystemDataTypeMapID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'The XmlSystem foreign key.', 'SCHEMA', N'dbo', 'TABLE', N'XmlSystemDataTypeMap', 'COLUMN', N'XmlSystemFID'
GO
Uses
Used By