Scribd
Upload
11 views8 pages

SQL Server Metadata XML Structure

I have no idea what this is I just put this here to get the 3 uploads for a free download

Uploaded by

jaycewilkinson7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
11 views8 pages

SQL Server Metadata XML Structure

I have no idea what this is I just put this here to get the 3 uploads for a free download

Uploaded by

jaycewilkinson7
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

1������ám�%���[Link]<?xml version="1.

0"
standalone="yes"?>
<NewDataSet>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs="[Link]
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="MetaDataCollections" msdata:MinimumCapacity="9">
<xs:complexType>
<xs:sequence>
<xs:element name="CollectionName" type="xs:string" minOccurs="0" />
<xs:element name="NumberOfRestrictions" type="xs:int" minOccurs="0" />
<xs:element name="NumberOfIdentifierParts" type="xs:int" minOccurs="0" />
<xs:element name="PopulationMechanism" type="xs:string" minOccurs="0" />
<xs:element name="PopulationString" type="xs:string" minOccurs="0" />
<xs:element name="MinimumVersion" type="xs:string" minOccurs="0" />
<xs:element name="MaximumVersion" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Restrictions" msdata:MinimumCapacity="3">
<xs:complexType>
<xs:sequence>
<xs:element name="CollectionName" type="xs:string" minOccurs="0" />
<xs:element name="RestrictionName" type="xs:string" minOccurs="0" />
<xs:element name="ParameterName" type="xs:string" minOccurs="0" />
<xs:element name="RestrictionDefault" type="xs:string" minOccurs="0" />
<xs:element name="RestrictionNumber" type="xs:int" minOccurs="0" />
<xs:element name="MinimumVersion" type="xs:string" minOccurs="0" />
<xs:element name="MaximumVersion" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DataSourceInformation" msdata:MinimumCapacity="18">
<xs:complexType>
<xs:sequence>
<xs:element name="CompositeIdentifierSeparatorPattern" type="xs:string"
minOccurs="0" />
<xs:element name="DataSourceProductName" type="xs:string" minOccurs="0" />
<xs:element name="DataSourceProductVersion" type="xs:string" minOccurs="0" />
<xs:element name="DataSourceProductVersionNormalized" type="xs:string"
minOccurs="0" />
<xs:element name="GroupByBehavior"
msdata:DataType="[Link], [Link],
Version=2.0.3500.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string"
minOccurs="0" />
<xs:element name="IdentifierPattern" type="xs:string" minOccurs="0" />
<xs:element name="IdentifierCase"
msdata:DataType="[Link], [Link], Version=2.0.3500.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" />
<xs:element name="OrderByColumnsInSelect" type="xs:boolean" minOccurs="0" />
<xs:element name="ParameterMarkerFormat" type="xs:string" minOccurs="0" />
<xs:element name="ParameterMarkerPattern" type="xs:string" minOccurs="0" />
<xs:element name="ParameterNameMaxLength" type="xs:int" minOccurs="0" />
<xs:element name="ParameterNamePattern" type="xs:string" minOccurs="0" />
<xs:element name="QuotedIdentifierPattern" type="xs:string" minOccurs="0" />
<xs:element name="QuotedIdentifierCase"
msdata:DataType="[Link], [Link], Version=2.0.3500.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string" minOccurs="0" />
<xs:element name="StatementSeparatorPattern" type="xs:string" minOccurs="0" />
<xs:element name="StringLiteralPattern" type="xs:string" minOccurs="0" />
<xs:element name="SupportedJoinOperators"
msdata:DataType="[Link], [Link],
Version=[Link], Culture=neutral, PublicKeyToken=b77a5c561934e089" type="xs:string"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DataTypes" msdata:MinimumCapacity="18">
<xs:complexType>
<xs:sequence>
<xs:element name="TypeName" type="xs:string" minOccurs="0" />
<xs:element name="ProviderDbType" type="xs:int" minOccurs="0" />
<xs:element name="ColumnSize" type="xs:long" minOccurs="0" />
<xs:element name="CreateFormat" type="xs:string" minOccurs="0" />
<xs:element name="CreateParameters" type="xs:string" minOccurs="0" />
<xs:element name="DataType" type="xs:string" minOccurs="0" />
<xs:element name="IsAutoIncrementable" type="xs:boolean" minOccurs="0" />
<xs:element name="IsBestMatch" type="xs:boolean" minOccurs="0" />
<xs:element name="IsCaseSensitive" type="xs:boolean" minOccurs="0" />
<xs:element name="IsFixedLength" type="xs:boolean" minOccurs="0" />
<xs:element name="IsFixedPrecisionScale" type="xs:boolean" minOccurs="0" />
<xs:element name="IsLong" type="xs:boolean" minOccurs="0" />
<xs:element name="IsNullable" type="xs:boolean" minOccurs="0" />
<xs:element name="IsSearchable" type="xs:boolean" minOccurs="0" />
<xs:element name="IsSearchableWithLike" type="xs:boolean" minOccurs="0" />
<xs:element name="IsUnsigned" type="xs:boolean" minOccurs="0" />
<xs:element name="MaximumScale" type="xs:short" minOccurs="0" />
<xs:element name="MinimumScale" type="xs:short" minOccurs="0" />
<xs:element name="IsConcurrencyType" type="xs:boolean" minOccurs="0" />
<xs:element name="MaximumVersion" type="xs:string" minOccurs="0" />
<xs:element name="MinimumVersion" type="xs:string" minOccurs="0" />
<xs:element name="IsLiteralSupported" type="xs:boolean" minOccurs="0" />
<xs:element name="LiteralPrefix" type="xs:string" minOccurs="0" />
<xs:element name="LiteralSuffix" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="ReservedWords" msdata:MinimumCapacity="3">
<xs:complexType>
<xs:sequence>
<xs:element name="ReservedWord" type="xs:string" minOccurs="0" />
<xs:element name="MaximumVersion" type="xs:string" minOccurs="0" />
<xs:element name="MinimumVersion" type="xs:string" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>
<MetaDataCollections>
<CollectionName>MetaDataCollections</CollectionName>
<NumberOfRestrictions>0</NumberOfRestrictions>
<NumberOfIdentifierParts>0</NumberOfIdentifierParts>
<PopulationMechanism>DataTable</PopulationMechanism>
<PopulationString>MetaDataCollections</PopulationString>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>DataSourceInformation</CollectionName>
<NumberOfRestrictions>0</NumberOfRestrictions>
<NumberOfIdentifierParts>0</NumberOfIdentifierParts>
<PopulationMechanism>DataTable</PopulationMechanism>
<PopulationString>DataSourceInformation</PopulationString>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>DataTypes</CollectionName>
<NumberOfRestrictions>0</NumberOfRestrictions>
<NumberOfIdentifierParts>0</NumberOfIdentifierParts>
<PopulationMechanism>PrepareCollection</PopulationMechanism>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Restrictions</CollectionName>
<NumberOfRestrictions>0</NumberOfRestrictions>
<NumberOfIdentifierParts>0</NumberOfIdentifierParts>
<PopulationMechanism>DataTable</PopulationMechanism>
<PopulationString>Restrictions</PopulationString>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>ReservedWords</CollectionName>
<NumberOfRestrictions>0</NumberOfRestrictions>
<NumberOfIdentifierParts>0</NumberOfIdentifierParts>
<PopulationMechanism>DataTable</PopulationMechanism>
<PopulationString>ReservedWords</PopulationString>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Users</CollectionName>
<NumberOfRestrictions>1</NumberOfRestrictions>
<NumberOfIdentifierParts>1</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select uid, name as user_name, createdate, updatedate from sysusers
where (name = @Name or (@Name is null))</PopulationString>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Databases</CollectionName>
<NumberOfRestrictions>1</NumberOfRestrictions>
<NumberOfIdentifierParts>1</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select name as database_name, dbid, crdate as create_date from
master..sysdatabases where (name = @Name or (@Name is null))</PopulationString>
<MaximumVersion>[Link]</MaximumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Databases</CollectionName>
<NumberOfRestrictions>1</NumberOfRestrictions>
<NumberOfIdentifierParts>1</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>IF OBJECT_ID('master..sysdatabases') IS NULL EXEC sp_executesql
N'select name as database_name, dbid, crdate as create_date from sysdatabases where (name
= @Name or (@Name is null))',N'@Name NVARCHAR(128)',@Name=@Name ELSE EXEC
sp_executesql N'select name as database_name, dbid, crdate as create_date from
master..sysdatabases where (name = @Name or (@Name is null))',N'@Name
NVARCHAR(128)',@Name=@Name</PopulationString>
<MinimumVersion>[Link]</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Tables</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>3</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME,
TABLE_TYPE from INFORMATION_SCHEMA.TABLES where (TABLE_CATALOG = @Catalog
or (@Catalog is null)) and (TABLE_SCHEMA = @Owner or (@Owner is null)) and
(TABLE_NAME = @Name or (@Name is null)) and (TABLE_TYPE = @TableType or
(@TableType is null))</PopulationString>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Columns</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>4</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME,
COLUMN_NAME, ORDINAL_POSITION, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH,
NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE,
DATETIME_PRECISION, CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA,
CHARACTER_SET_NAME, COLLATION_CATALOG from
INFORMATION_SCHEMA.COLUMNS where (TABLE_CATALOG = @Catalog or (@Catalog is
null)) and (TABLE_SCHEMA = @Owner or (@Owner is null)) and (TABLE_NAME = @Table or
(@Table is null)) and (COLUMN_NAME = @Column or (@Column is null)) order by
TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME</PopulationString>
<MaximumVersion>[Link]</MaximumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Columns</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>4</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>EXEC sys.sp_columns_managed @Catalog, @Owner, @Table,
@Column, 0</PopulationString>
<MinimumVersion>[Link]</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>AllColumns</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>4</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>EXEC sys.sp_columns_managed @Catalog, @Owner, @Table,
@Column, 1</PopulationString>
<MinimumVersion>[Link]</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>ColumnSetColumns</CollectionName>
<NumberOfRestrictions>3</NumberOfRestrictions>
<NumberOfIdentifierParts>3</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>EXEC sys.sp_columns_managed @Catalog, @Owner, @Table, null,
2</PopulationString>
<MinimumVersion>[Link]</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>StructuredTypeMembers</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>4</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>SELECT DB_NAME() AS TYPE_CATALOG, [Link] AS
TYPE_SCHEMA, [Link] AS TYPE_NAME, [Link] AS MEMBER_NAME,
ColumnProperty(c.object_id, [Link], 'ordinal') AS ORDINAL_POSITION,
convert(nvarchar(4000), object_definition(c.default_object_id)) AS MEMBER_DEFAULT,
convert(varchar(3), CASE c.is_nullable WHEN 1 THEN 'YES' ELSE 'NO' END) AS
IS_NULLABLE, type_name(c.system_type_id) AS DATA_TYPE, ColumnProperty(c.object_id,
[Link], 'charmaxlen') AS CHARACTER_MAXIMUM_LENGTH, ColumnProperty(c.object_id,
[Link], 'octetmaxlen') AS CHARACTER_OCTET_LENGTH, convert(tinyint, CASE /*
int/decimal/numeric/real/float/money */ WHEN c.system_type_id IN (48, 52, 56, 59, 60, 62, 106,
108, 122, 127) THEN [Link] END) AS NUMERIC_PRECISION, convert(smallint, CASE /*
int/money/decimal/numeric */ WHEN c.system_type_id IN (48, 52, 56, 60, 106, 108, 122, 127)
THEN 10 WHEN c.system_type_id IN (59, 62) THEN 2 END) AS
NUMERIC_PRECISION_RADIX, /* real/float */ convert(int, CASE /* datetime/smalldatetime */
WHEN c.system_type_id IN (58, 61) THEN NULL ELSE odbcscale(c.system_type_id, [Link])
END) AS NUMERIC_SCALE, convert(smallint, CASE /* datetime/smalldatetime */ WHEN
c.system_type_id IN (58, 61) THEN 3 END) AS DATETIME_PRECISION, convert(sysname,
null) AS CHARACTER_SET_CATALOG, convert(sysname, null) AS
CHARACTER_SET_SCHEMA, convert(sysname, CASE WHEN c.system_type_id IN (35, 167,
175) /*char/varchar/text*/ THEN CollationProperty(c.collation_name, 'sqlcharsetname') WHEN
c.system_type_id IN (99, 231, 239) /*nchar/nvarchar/ntext*/ THEN N'UNICODE' END) AS
CHARACTER_SET_NAME, convert(sysname, null) AS COLLATION_CATALOG FROM
[Link] sc join [Link] o on sc.schema_id = o.schema_id JOIN sys.table_types tt on
o.object_id = tt.type_table_object_id JOIN [Link] c ON c.object_id = o.object_id LEFT
JOIN [Link] t ON c.user_type_id = t.user_type_id WHERE [Link] IN ('TT') AND
(DB_NAME() = @Catalog or (@Catalog is null)) and ([Link] = @Owner or (@Owner is null))
and ([Link] = @Type or (@Type is null)) and ([Link] = @Member or (@Member is null))
order by [Link], [Link], [Link]</PopulationString>
<MinimumVersion>[Link]</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Views</CollectionName>
<NumberOfRestrictions>3</NumberOfRestrictions>
<NumberOfIdentifierParts>3</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME,
CHECK_OPTION, IS_UPDATABLE from INFORMATION_SCHEMA.VIEWS where
(TABLE_CATALOG = @Catalog or (@Catalog is null)) and (TABLE_SCHEMA = @Owner or
(@Owner is null)) and (TABLE_NAME = @Table or (@Table is null)) order by
TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME</PopulationString>
<MinimumVersion>[Link]</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>ViewColumns</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>4</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select VIEW_CATALOG, VIEW_SCHEMA, VIEW_NAME,
TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME from
INFORMATION_SCHEMA.VIEW_COLUMN_USAGE where (VIEW_CATALOG = @Catalog or
(@Catalog is null)) and (VIEW_SCHEMA = @Owner or (@Owner is null)) and (VIEW_NAME =
@Table or (@Table is null)) and (COLUMN_NAME = @Column or (@Column is null)) order by
VIEW_CATALOG, VIEW_SCHEMA, VIEW_NAME</PopulationString>
<MinimumVersion>[Link]</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>ProcedureParameters</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>1</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME,
ORDINAL_POSITION, PARAMETER_MODE, IS_RESULT, AS_LOCATOR,
PARAMETER_NAME, CASE WHEN DATA_TYPE IS NULL THEN
USER_DEFINED_TYPE_NAME WHEN DATA_TYPE = 'table type' THEN
USER_DEFINED_TYPE_NAME ELSE DATA_TYPE END as DATA_TYPE,
CHARACTER_MAXIMUM_LENGTH, CHARACTER_OCTET_LENGTH,
COLLATION_CATALOG, COLLATION_SCHEMA, COLLATION_NAME,
CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA, CHARACTER_SET_NAME,
NUMERIC_PRECISION, NUMERIC_PRECISION_RADIX, NUMERIC_SCALE,
DATETIME_PRECISION, INTERVAL_TYPE, INTERVAL_PRECISION from
INFORMATION_SCHEMA.PARAMETERS where (SPECIFIC_CATALOG = @Catalog or
(@Catalog is null)) and (SPECIFIC_SCHEMA = @Owner or (@Owner is null)) and
(SPECIFIC_NAME = @Name or (@Name is null)) and (PARAMETER_NAME = @Parameter or
(@Parameter is null)) order by SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME,
PARAMETER_NAME</PopulationString>
<MinimumVersion>08.00.0000</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>Procedures</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>3</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select SPECIFIC_CATALOG, SPECIFIC_SCHEMA, SPECIFIC_NAME,
ROUTINE_CATALOG, ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_TYPE, CREATED,
LAST_ALTERED from INFORMATION_SCHEMA.ROUTINES where (SPECIFIC_CATALOG =
@Catalog or (@Catalog is null)) and (SPECIFIC_SCHEMA = @Owner or (@Owner is null)) and
(SPECIFIC_NAME = @Name or (@Name is null)) and (ROUTINE_TYPE = @Type or (@Type
is null)) order by SPECIFIC_CATALOG, SPECIFIC_SCHEMA,
SPECIFIC_NAME</PopulationString>
<MinimumVersion>08.00.0000</MinimumVersion>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>ForeignKeys</CollectionName>
<NumberOfRestrictions>4</NumberOfRestrictions>
<NumberOfIdentifierParts>3</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</PopulationMechanism>
<PopulationString>select CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA,
CONSTRAINT_NAME, TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME,
CONSTRAINT_TYPE, IS_DEFERRABLE, INITIALLY_DEFERRED from
INFORMATION_SCHEMA.TABLE_CONSTRAINTS where (CONSTRAINT_CATALOG =
@Catalog or (@Catalog is null)) and (CONSTRAINT_SCHEMA = @Owner or (@Owner is null))
and (TABLE_NAME = @Table or (@Table is null)) and (CONSTRAINT_NAME = @Name or
(@Name is null)) and CONSTRAINT_TYPE = 'FOREIGN KEY' order by
CONSTRAINT_CATALOG, CONSTRAINT_SCHEMA,
CONSTRAINT_NAME</PopulationString>
</MetaDataCollections>
<MetaDataCollections>
<CollectionName>IndexColumns</CollectionName>
<NumberOfRestrictions>5</NumberOfRestrictions>
<NumberOfIdentifierParts>4</NumberOfIdentifierParts>
<PopulationMechanism>SQLCommand</

You might also like