Skip to content

Instantly share code, notes, and snippets.

@swasheck

swasheck/MyRelOpBringsAllTheNerdsToTheYard.xml

Created August 7, 2014 19:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save swasheck/da2e2d4e459d5f1917fd to your computer and use it in GitHub Desktop.
Save swasheck/da2e2d4e459d5f1917fd to your computer and use it in GitHub Desktop.
Download ZIP
MyRelOpBringsAllTheNerdsToTheYard.xml
Raw
MyRelOpBringsAllTheNerdsToTheYard.xml
<data name="showplan_xml">
<value>
<ShowPlanXML xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan" Version="1.2" Build="12.0.2000.8">
<BatchSequence>
<Batch>
<Statements>
<StmtSimple StatementSubTreeCost="0.0783322" StatementEstRows="2.03781" StatementOptmLevel="FULL" QueryHash="0xDFC40696863DF555" QueryPlanHash="0xC4973D76B2B6B7B7" StatementOptmEarlyAbortReason="GoodEnoughPlanFound" CardinalityEstimationModelVersion="120">
<QueryPlan DegreeOfParallelism="0" MemoryGrant="1120" NonParallelPlanReason="CouldNotGenerateValidParallelPlan" CachedPlanSize="424" CompileTime="152" CompileCPU="113" CompileMemory="8112">
<MemoryGrantInfo SerialRequiredMemory="1024" SerialDesiredMemory="1120" RequiredMemory="1024" DesiredMemory="1120" RequestedMemory="1120" GrantWaitTime="0" GrantedMemory="1120" MaxUsedMemory="16" />
<OptimizerHardwareDependentProperties EstimatedAvailableMemoryGrant="671078" EstimatedPagesCached="167769" EstimatedAvailableDegreeOfParallelism="2" />
<RelOp NodeId="1" PhysicalOp="Sort" LogicalOp="Sort" EstimateRows="2.03781" EstimateIO="0.0112613" EstimateCPU="0.000111752" AvgRowSize="8487" EstimatedTotalSubtreeCost="0.0783322" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1226" />
<ColumnReference Column="Union1227" />
<ColumnReference Column="Union1228" />
<ColumnReference Column="Union1229" />
<ColumnReference Column="Union1230" />
<ColumnReference Column="Union1231" />
<ColumnReference Column="Union1232" />
<ColumnReference Column="Union1233" />
<ColumnReference Column="Union1234" />
<ColumnReference Column="Union1235" />
<ColumnReference Column="Union1237" />
<ColumnReference Column="Union1238" />
<ColumnReference Column="Union1242" />
<ColumnReference Column="Union1245" />
<ColumnReference Column="Union1248" />
<ColumnReference Column="Union1249" />
<ColumnReference Column="Union1250" />
<ColumnReference Column="Union1252" />
<ColumnReference Column="Union1255" />
<ColumnReference Column="Union1258" />
<ColumnReference Column="Union1261" />
<ColumnReference Column="Union1264" />
<ColumnReference Column="Union1267" />
<ColumnReference Column="Union1270" />
<ColumnReference Column="Union1271" />
<ColumnReference Column="Union1272" />
<ColumnReference Column="Union1273" />
<ColumnReference Column="Union1274" />
<ColumnReference Column="Union1277" />
<ColumnReference Column="Union1280" />
<ColumnReference Column="Union1281" />
<ColumnReference Column="Union1284" />
<ColumnReference Column="Union1285" />
<ColumnReference Column="Union1286" />
<ColumnReference Column="Union1287" />
<ColumnReference Column="Union1288" />
<ColumnReference Column="Union1289" />
<ColumnReference Column="Union1290" />
<ColumnReference Column="Union1291" />
<ColumnReference Column="Union1292" />
<ColumnReference Column="Union1293" />
</OutputList>
<MemoryFractions Input="0.666667" Output="1" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="0">
<OrderBy>
<OrderByColumn Ascending="1">
<ColumnReference Column="Union1226" />
</OrderByColumn>
<OrderByColumn Ascending="1">
<ColumnReference Column="Union1227" />
</OrderByColumn>
<OrderByColumn Ascending="1">
<ColumnReference Column="Union1228" />
</OrderByColumn>
<OrderByColumn Ascending="1">
<ColumnReference Column="Union1232" />
</OrderByColumn>
</OrderBy>
<RelOp NodeId="2" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2.03781" EstimateIO="0" EstimateCPU="2.03781e-007" AvgRowSize="8487" EstimatedTotalSubtreeCost="0.0669592" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Union1226" />
<ColumnReference Column="Union1227" />
<ColumnReference Column="Union1228" />
<ColumnReference Column="Union1229" />
<ColumnReference Column="Union1230" />
<ColumnReference Column="Union1231" />
<ColumnReference Column="Union1232" />
<ColumnReference Column="Union1233" />
<ColumnReference Column="Union1234" />
<ColumnReference Column="Union1235" />
<ColumnReference Column="Union1237" />
<ColumnReference Column="Union1238" />
<ColumnReference Column="Union1241" />
<ColumnReference Column="Union1242" />
<ColumnReference Column="Union1245" />
<ColumnReference Column="Union1248" />
<ColumnReference Column="Union1249" />
<ColumnReference Column="Union1250" />
<ColumnReference Column="Union1252" />
<ColumnReference Column="Union1255" />
<ColumnReference Column="Union1258" />
<ColumnReference Column="Union1261" />
<ColumnReference Column="Union1264" />
<ColumnReference Column="Union1267" />
<ColumnReference Column="Union1270" />
<ColumnReference Column="Union1271" />
<ColumnReference Column="Union1272" />
<ColumnReference Column="Union1273" />
<ColumnReference Column="Union1274" />
<ColumnReference Column="Union1277" />
<ColumnReference Column="Union1280" />
<ColumnReference Column="Union1281" />
<ColumnReference Column="Union1284" />
<ColumnReference Column="Union1285" />
<ColumnReference Column="Union1286" />
<ColumnReference Column="Union1287" />
<ColumnReference Column="Union1288" />
<ColumnReference Column="Union1289" />
<ColumnReference Column="Union1290" />
<ColumnReference Column="Union1291" />
<ColumnReference Column="Union1292" />
<ColumnReference Column="Union1293" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Union1226" />
<ColumnReference Column="Expr1075" />
<ColumnReference Column="Expr1161" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1227" />
<ColumnReference Column="Expr1076" />
<ColumnReference Column="Expr1162" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1228" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1229" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Column="Expr1151" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1230" />
<ColumnReference Column="Expr1077" />
<ColumnReference Column="Expr1163" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1231" />
<ColumnReference Column="Expr1078" />
<ColumnReference Column="Expr1164" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1232" />
<ColumnReference Column="Expr1079" />
<ColumnReference Column="Expr1165" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1233" />
<ColumnReference Column="Expr1080" />
<ColumnReference Column="Expr1166" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1234" />
<ColumnReference Column="Expr1081" />
<ColumnReference Column="Expr1167" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1235" />
<ColumnReference Column="Expr1082" />
<ColumnReference Column="Expr1168" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1237" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1135" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1238" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1241" />
<ColumnReference Column="Expr1086" />
<ColumnReference Column="Expr1172" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1242" />
<ColumnReference Column="Expr1087" />
<ColumnReference Column="Expr1173" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1245" />
<ColumnReference Column="Expr1090" />
<ColumnReference Column="Expr1176" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1248" />
<ColumnReference Column="Expr1093" />
<ColumnReference Column="Expr1179" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1249" />
<ColumnReference Column="Expr1094" />
<ColumnReference Column="Expr1180" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1250" />
<ColumnReference Column="Expr1095" />
<ColumnReference Column="Expr1181" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1252" />
<ColumnReference Column="Expr1097" />
<ColumnReference Column="Expr1183" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1255" />
<ColumnReference Column="Expr1100" />
<ColumnReference Column="Expr1186" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1258" />
<ColumnReference Column="Expr1103" />
<ColumnReference Column="Expr1189" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1261" />
<ColumnReference Column="Expr1106" />
<ColumnReference Column="Expr1192" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1264" />
<ColumnReference Column="Expr1109" />
<ColumnReference Column="Expr1195" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1267" />
<ColumnReference Column="Expr1001" />
<ColumnReference Column="Expr1152" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1270" />
<ColumnReference Column="Expr1114" />
<ColumnReference Column="Expr1200" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1271" />
<ColumnReference Column="Expr1115" />
<ColumnReference Column="Expr1201" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1272" />
<ColumnReference Column="Expr1116" />
<ColumnReference Column="Expr1202" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1273" />
<ColumnReference Column="Expr1117" />
<ColumnReference Column="Expr1203" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1274" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1204" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1277" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1207" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1280" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1210" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1281" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1211" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1284" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1214" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1285" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1215" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1286" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1216" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1287" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
<ColumnReference Column="Expr1217" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1288" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1218" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1289" />
<ColumnReference Column="Expr1132" />
<ColumnReference Column="Expr1219" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1290" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="name" />
<ColumnReference Column="Expr1220" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1291" />
<ColumnReference Column="Expr1073" />
<ColumnReference Column="Expr1221" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1292" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1222" />
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Union1293" />
<ColumnReference Column="Expr1014" />
<ColumnReference Column="Expr1223" />
</DefinedValue>
</DefinedValues>
<RelOp NodeId="3" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1.03781" EstimateIO="0" EstimateCPU="1.03781e-007" AvgRowSize="8487" EstimatedTotalSubtreeCost="0.0384247" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Column="Expr1001" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="name" />
<ColumnReference Column="Expr1073" />
<ColumnReference Column="Expr1075" />
<ColumnReference Column="Expr1076" />
<ColumnReference Column="Expr1077" />
<ColumnReference Column="Expr1078" />
<ColumnReference Column="Expr1079" />
<ColumnReference Column="Expr1080" />
<ColumnReference Column="Expr1081" />
<ColumnReference Column="Expr1082" />
<ColumnReference Column="Expr1086" />
<ColumnReference Column="Expr1087" />
<ColumnReference Column="Expr1090" />
<ColumnReference Column="Expr1093" />
<ColumnReference Column="Expr1094" />
<ColumnReference Column="Expr1095" />
<ColumnReference Column="Expr1097" />
<ColumnReference Column="Expr1100" />
<ColumnReference Column="Expr1103" />
<ColumnReference Column="Expr1106" />
<ColumnReference Column="Expr1109" />
<ColumnReference Column="Expr1114" />
<ColumnReference Column="Expr1115" />
<ColumnReference Column="Expr1116" />
<ColumnReference Column="Expr1117" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1124" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1129" />
<ColumnReference Column="Expr1130" />
<ColumnReference Column="Expr1131" />
<ColumnReference Column="Expr1132" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1075" />
<ScalarOperator ScalarString="db_name()">
<Identifier>
<ColumnReference Column="ConstExpr1294">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1077" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1078" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1082" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[is_long] as [d].[is_long]=(1) OR [imeta].[sys].[syscolpars].[length] as [c].[length]=(-1) THEN (130) ELSE (0) END|[Expr1335]|[Expr1336]|CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(189) THEN (512) ELSE CASE WHEN CONVERT(bit,[imeta].[sys].[syscolpars].[status] as [c].[status]&amp;(4),0)&lt;&gt;(1) AND has_perms_by_name(quotename(schema_name([imeta].[sys].[sysschobjs].[nsid] as [o].[nsid]))+N'.'+quotename([imeta].[sys].[sysschobjs].[name] as [o].[name]),N'OBJECT',N'UPDATE',quotename([imeta].[sys].[syscolpars].[name] as [c].[name]),N'COLUMN')=(1) THEN (4) ELSE (0) END END|[Expr1337]">
<Arithmetic Operation="BIT_OR">
<ScalarOperator>
<Arithmetic Operation="BIT_OR">
<ScalarOperator>
<Arithmetic Operation="BIT_OR">
<ScalarOperator>
<Arithmetic Operation="BIT_OR">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1335" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1336" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(189)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(512)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="NE">
<ScalarOperator>
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="has_perms_by_name">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'.'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'OBJECT'" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'UPDATE'" />
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'COLUMN'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1337" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1086" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1087" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(128) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN isnull([mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size],CASE WHEN [imeta].[sys].[syscolpars].[length] as [c].[length]=(-1) THEN (0) ELSE CONVERT_IMPLICIT(int,[imeta].[sys].[syscolpars].[length] as [c].[length],0) END) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) THEN CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size] IS NOT NULL THEN [mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size] ELSE CONVERT_IMPLICIT(int,[imeta].[sys].[syscolpars].[length] as [c].[length],0)/(2) END ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(132) AND [imeta].[sys].[syscolpars].[length] as [c].[length]=(-1) THEN (0) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(132) THEN CONVERT_IMPLICIT(int,[imeta].[sys].[syscolpars].[length] as [c].[length],0) ELSE NULL END END END END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(128)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Arithmetic Operation="DIV">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(132)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(132)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1090" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(128) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN isnull([mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size],CASE WHEN [imeta].[sys].[syscolpars].[length] as [c].[length]=(-1) THEN (0) ELSE CONVERT_IMPLICIT(int,[imeta].[sys].[syscolpars].[length] as [c].[length],0) END) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) THEN isnull([mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size]*(2),CASE WHEN [imeta].[sys].[syscolpars].[length] as [c].[length]=(-1) THEN (0) ELSE CONVERT_IMPLICIT(int,[imeta].[sys].[syscolpars].[length] as [c].[length],0) END) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(132) AND [imeta].[sys].[syscolpars].[length] as [c].[length]=(-1) THEN (0) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(132) THEN CONVERT_IMPLICIT(int,[imeta].[sys].[syscolpars].[length] as [c].[length],0) ELSE NULL END END END END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(128)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Arithmetic Operation="MULT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(132)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(132)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1093" />
<ScalarOperator ScalarString="CONVERT(smallint,CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(131) THEN CONVERT_IMPLICIT(int,[imeta].[sys].[syscolpars].[prec] as [c].[prec],0) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[fixed_prec_scale] as [d].[fixed_prec_scale]=(1) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(4) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(5) THEN [mssqlsystemresource].[sys].[spt_provider_types].[data_precision] as [d].[data_precision] ELSE NULL END END,0)">
<Convert DataType="smallint" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(131)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(5)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1094" />
<ScalarOperator ScalarString="CONVERT(smallint,CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(131) THEN odbcscale([imeta].[sys].[syscolpars].[xtype] as [c].[xtype],[imeta].[sys].[syscolpars].[scale] as [c].[scale]) ELSE NULL END,0)">
<Convert DataType="smallint" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(131)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="odbcscale">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1095" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(43) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(42) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(41) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(40) THEN CONVERT_IMPLICIT(int,[imeta].[sys].[syscolpars].[scale] as [c].[scale],0) ELSE [mssqlsystemresource].[sys].[spt_provider_types].[datetime_precision] as [d].[datetime_precision] END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(43)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(42)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(41)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(40)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1103" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN collationproperty(CONVERT(nvarchar(128),collationpropertyfromid([imeta].[sys].[syscolpars].[collationid] as [c].[collationid],'name'),0),'sqlcharsetname') ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="collationproperty">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationpropertyfromid">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'name'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'sqlcharsetname'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1114" />
<ScalarOperator ScalarString="CASE WHEN [imeta].[sys].[syscolpars].[utype] as [c].[utype]&lt;(256) THEN NULL ELSE db_name() END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(256)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1301">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1115" />
<ScalarOperator ScalarString="CASE WHEN [imeta].[sys].[syscolpars].[utype] as [c].[utype]&lt;(256) THEN NULL ELSE schema_name([imeta].[sys].[sysschobjs].[nsid] as [o].[nsid]) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(256)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1117" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1124" />
<ScalarOperator ScalarString="CASE WHEN CONVERT(int,databasepropertyex(db_name(),'sqlsortorder'),0)=(0) THEN NULL ELSE CONVERT(int,databasepropertyex(db_name(),'sqlsortorder'),0) END">
<Identifier>
<ColumnReference Column="ConstExpr1308">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="databasepropertyex">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'sqlsortorder'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="databasepropertyex">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'sqlsortorder'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1129" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(241) AND [imeta].[sys].[sysnsobjs].[name] as [s].[name] IS NOT NULL THEN db_name() ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(241)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1312">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1130" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(241) AND [imeta].[sys].[sysnsobjs].[name] as [s].[name] IS NOT NULL THEN schema_name([imeta].[sys].[sysnsobjs].[nsid] as [s].[nsid]) ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(241)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="nsid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1131" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(240) THEN db_name() ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(240)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1313">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1132" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),schema_name([imeta].[sys].[sysscalartypes].[schid] as [t].[schid]),0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="schid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="4" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1.03781" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="7438" EstimatedTotalSubtreeCost="0.0384246" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
<ColumnReference Column="Expr1001" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="nsid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="schid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="name" />
<ColumnReference Column="Expr1073" />
<ColumnReference Column="Expr1076" />
<ColumnReference Column="Expr1079" />
<ColumnReference Column="Expr1080" />
<ColumnReference Column="Expr1081" />
<ColumnReference Column="Expr1097" />
<ColumnReference Column="Expr1100" />
<ColumnReference Column="Expr1106" />
<ColumnReference Column="Expr1109" />
<ColumnReference Column="Expr1116" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1335" />
<ColumnReference Column="Expr1336" />
<ColumnReference Column="Expr1337" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
</OuterReferences>
<RelOp NodeId="5" PhysicalOp="Nested Loops" LogicalOp="Left Outer Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="3301" EstimatedTotalSubtreeCost="0.0318491" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
<ColumnReference Column="Expr1001" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="nsid" />
<ColumnReference Column="Expr1076" />
<ColumnReference Column="Expr1079" />
<ColumnReference Column="Expr1080" />
<ColumnReference Column="Expr1081" />
<ColumnReference Column="Expr1097" />
<ColumnReference Column="Expr1100" />
<ColumnReference Column="Expr1106" />
<ColumnReference Column="Expr1109" />
<ColumnReference Column="Expr1116" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1335" />
<ColumnReference Column="Expr1336" />
<ColumnReference Column="Expr1337" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
</OuterReferences>
<RelOp NodeId="6" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="3171" EstimatedTotalSubtreeCost="0.0285605" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
<ColumnReference Column="Expr1001" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
<ColumnReference Column="Expr1076" />
<ColumnReference Column="Expr1079" />
<ColumnReference Column="Expr1080" />
<ColumnReference Column="Expr1081" />
<ColumnReference Column="Expr1097" />
<ColumnReference Column="Expr1100" />
<ColumnReference Column="Expr1106" />
<ColumnReference Column="Expr1109" />
<ColumnReference Column="Expr1116" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1335" />
<ColumnReference Column="Expr1336" />
<ColumnReference Column="Expr1337" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1097" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN N'master' ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="N'master'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1100" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN N'dbo' ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="N'dbo'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1106" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN N'master' ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="N'master'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1109" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN N'dbo' ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="N'dbo'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1335" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[fixlen] as [d].[fixlen] IS NOT NULL THEN (16) ELSE (0) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixlen" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(16)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1337" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(43) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(42) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(41) THEN (1073741824) ELSE (0) END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(43)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(42)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(41)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(1073741824)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="7" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="2647" EstimatedTotalSubtreeCost="0.0285604" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
<ColumnReference Column="Expr1001" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixlen" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
<ColumnReference Column="Expr1076" />
<ColumnReference Column="Expr1079" />
<ColumnReference Column="Expr1080" />
<ColumnReference Column="Expr1081" />
<ColumnReference Column="Expr1116" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1336" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
</OuterReferences>
<RelOp NodeId="8" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="2627" EstimatedTotalSubtreeCost="0.0252731" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
<ColumnReference Column="Expr1001" />
<ColumnReference Column="Expr1002" />
<ColumnReference Column="Expr1013" />
<ColumnReference Column="Expr1014" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Column="Expr1076" />
<ColumnReference Column="Expr1079" />
<ColumnReference Column="Expr1080" />
<ColumnReference Column="Expr1081" />
<ColumnReference Column="Expr1116" />
<ColumnReference Column="Expr1118" />
<ColumnReference Column="Expr1121" />
<ColumnReference Column="Expr1125" />
<ColumnReference Column="Expr1128" />
<ColumnReference Column="Expr1336" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1001" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),collationpropertyfromid([imeta].[sys].[syscolpars].[collationid] as [c].[collationid],'name'),0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationpropertyfromid">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'name'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1002" />
<ScalarOperator ScalarString="CONVERT(bit,(1)-([imeta].[sys].[syscolpars].[status] as [c].[status]&amp;(1)),0)">
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="SUB">
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1013" />
<ScalarOperator ScalarString="CONVERT(bit,[imeta].[sys].[syscolpars].[status] as [c].[status]&amp;(16777216),0)">
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(16777216)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1014" />
<ScalarOperator ScalarString="CONVERT(bit,[imeta].[sys].[syscolpars].[status] as [c].[status]&amp;(33554432),0)">
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(33554432)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1079" />
<ScalarOperator ScalarString="columnproperty([imeta].[sys].[syscolpars].[id] as [c].[id],[imeta].[sys].[syscolpars].[name] as [c].[name],'ordinal')">
<Intrinsic FunctionName="columnproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'ordinal'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1080" />
<ScalarOperator ScalarString="CONVERT(bit,CASE WHEN columnproperty([imeta].[sys].[syscolpars].[id] as [c].[id],[imeta].[sys].[syscolpars].[name] as [c].[name],'default')=(0) THEN (0) ELSE (1) END,0)">
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="columnproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'default'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1081" />
<ScalarOperator ScalarString="CONVERT(nvarchar(2000),object_definition(columnproperty([imeta].[sys].[syscolpars].[id] as [c].[id],[imeta].[sys].[syscolpars].[name] as [c].[name],'default')),0)">
<Convert DataType="nvarchar" Length="4000" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="object_definition">
<ScalarOperator>
<Intrinsic FunctionName="columnproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'default'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1116" />
<ScalarOperator ScalarString="CASE WHEN [imeta].[sys].[syscolpars].[utype] as [c].[utype]&lt;(256) THEN NULL ELSE type_name([imeta].[sys].[syscolpars].[utype] as [c].[utype]) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(256)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Intrinsic FunctionName="type_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1118" />
<ScalarOperator ScalarString="CONVERT(int,collationproperty(CONVERT(nvarchar(128),collationpropertyfromid([imeta].[sys].[syscolpars].[collationid] as [c].[collationid],'name'),0),'lcid'),0)">
<Convert DataType="int" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationproperty">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationpropertyfromid">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'name'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'lcid'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1121" />
<ScalarOperator ScalarString="CONVERT(int,collationproperty(CONVERT(nvarchar(128),collationpropertyfromid([imeta].[sys].[syscolpars].[collationid] as [c].[collationid],'name'),0),'oledbcompstyle'),0)">
<Convert DataType="int" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationproperty">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationpropertyfromid">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'name'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'oledbcompstyle'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1125" />
<ScalarOperator ScalarString="CONVERT(binary(5),collationproperty(CONVERT(nvarchar(128),collationpropertyfromid([imeta].[sys].[syscolpars].[collationid] as [c].[collationid],'name'),0),'TDSCollation'),0)">
<Convert DataType="binary" Length="5" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationproperty">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationpropertyfromid">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'name'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'TDSCollation'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1128" />
<ScalarOperator ScalarString="CONVERT(bit,columnproperty([imeta].[sys].[syscolpars].[id] as [c].[id],[imeta].[sys].[syscolpars].[name] as [c].[name],'IsComputed'),0)">
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="columnproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'IsComputed'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1336" />
<ScalarOperator ScalarString="CASE WHEN CONVERT(bit,(1)-([imeta].[sys].[syscolpars].[status] as [c].[status]&amp;(1)),0)=(1) THEN (96) ELSE (0) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="SUB">
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(96)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="9" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="345" EstimatedTotalSubtreeCost="0.025273" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Column="Expr1076" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Column="Expr1338" />
<ColumnReference Column="Expr1340" />
</OuterReferences>
<RelOp NodeId="10" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="716" EstimatedTotalSubtreeCost="0.0219544" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Column="Expr1076" />
<ColumnReference Column="Expr1338" />
<ColumnReference Column="Expr1340" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1076" />
<ScalarOperator ScalarString="schema_name([imeta].[sys].[sysschobjs].[nsid] as [o].[nsid])">
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1338" />
<ScalarOperator ScalarString="objectproperty([imeta].[sys].[sysschobjs].[id] as [o].[id],'tablehascolumnset')">
<Intrinsic FunctionName="objectproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'tablehascolumnset'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1340" />
<ScalarOperator ScalarString="quotename(schema_name([imeta].[sys].[sysschobjs].[nsid] as [o].[nsid]))+N'.'+quotename([imeta].[sys].[sysschobjs].[name] as [o].[name])">
<Arithmetic Operation="ADD">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'.'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="11" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="3.87052e-006" AvgRowSize="63" EstimatedTotalSubtreeCost="0.0219543" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Filter StartupExpression="0">
<RelOp NodeId="12" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.5002" EstimateIO="0" EstimateCPU="6.27085e-006" AvgRowSize="70" EstimatedTotalSubtreeCost="0.0219504" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</OuterReferences>
<RelOp NodeId="13" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="1.5002" EstimateIO="0.0112613" EstimateCPU="0.000103183" AvgRowSize="63" EstimatedTotalSubtreeCost="0.0179331" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<MemoryFractions Input="1" Output="0.333333" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="1">
<OrderBy>
<OrderByColumn Ascending="1">
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</OrderByColumn>
</OrderBy>
<RelOp NodeId="14" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-007" AvgRowSize="63" EstimatedTotalSubtreeCost="0.00656866" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</DefinedValue>
</DefinedValues>
<RelOp NodeId="15" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="6.8e-007" AvgRowSize="63" EstimatedTotalSubtreeCost="0.00328378" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Filter StartupExpression="1">
<RelOp NodeId="16" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="64" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2462" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</DefinedValue>
</DefinedValues>
<Object Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Index="[nc2]" Alias="[o]" TableReferenceId="1" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[@table_name]">
<Identifier>
<ColumnReference Column="@table_name" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[nsclass] as [o].[nsclass]=(0)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsclass" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[@table_schema] IS NULL">
<Identifier>
<ColumnReference Column="ConstExpr1332">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@table_schema" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp NodeId="18" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="67" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2462" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</DefinedValue>
</DefinedValues>
<Object Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Index="[clst]" Alias="[o]" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="object_id(quotename([@table_schema])+N'.'+quotename([@table_name]))">
<Identifier>
<ColumnReference Column="ConstExpr1333">
<ScalarOperator>
<Intrinsic FunctionName="object_id">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@table_schema" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'.'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@table_name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[nsclass] as [o].[nsclass]=(0) AND [imeta].[sys].[sysschobjs].[pclass] as [o].[pclass]=(1) AND ([imeta].[sys].[sysschobjs].[type] as [o].[type]='U' OR [imeta].[sys].[sysschobjs].[type] as [o].[type]='V')">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsclass" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="pclass" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'U'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'V'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Concat>
</RelOp>
</Sort>
</RelOp>
<RelOp NodeId="20" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="14" EstimatedTotalSubtreeCost="0.00401106" TableCardinality="2462" Parallel="0" EstimateRebinds="0.500203" EstimateRewinds="2.21924e-016" EstimatedExecutionMode="Row">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="1" ActualEndOfScans="0" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues />
<Object Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Index="[clst]" Alias="[o]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[id] as [o].[id]">
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[pclass] as [o].[pclass]=(1) AND CONVERT(bit,[imeta].[sys].[sysschobjs].[status2] as [o].[status2]&amp;(32),0)=(0) AND ([imeta].[sys].[sysschobjs].[type] as [o].[type]='U' OR [imeta].[sys].[sysschobjs].[type] as [o].[type]='V')">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="pclass" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="status2" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(32)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'U'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'V'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="has_access('CO',[imeta].[sys].[sysschobjs].[id] as [o].[id])=(1)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="has_access">
<ScalarOperator>
<Const ConstValue="'CO'" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="30" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="2.46438e-005" AvgRowSize="165" EstimatedTotalSubtreeCost="0.00331443" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Filter StartupExpression="0">
<RelOp NodeId="31" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.00016479" AvgRowSize="165" EstimatedTotalSubtreeCost="0.00328979" TableCardinality="1816" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="length" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="prec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="scale" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="collationid" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
</DefinedValue>
</DefinedValues>
<Object Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Index="[clst]" Alias="[c]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="number" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[id] as [o].[id]">
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="([@column_name]=[imeta].[sys].[syscolpars].[name] as [c].[name] OR [@column_name] IS NULL) AND (CONVERT(bit,[imeta].[sys].[syscolpars].[status] as [c].[status]&amp;(16777216),0)=(0) OR [Expr1338]=(0))">
<Logical Operation="AND">
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@column_name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
</Identifier>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1334">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@column_name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(16777216)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1338" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="has_perms_by_name([Expr1340],N'object',N'select',quotename([imeta].[sys].[syscolpars].[name] as [c].[name]),N'column')=(1) AND has_access('CO',[imeta].[sys].[syscolpars].[id] as [c].[id])=(1)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="has_perms_by_name">
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1340" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'object'" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'select'" />
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'column'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="has_access">
<ScalarOperator>
<Const ConstValue="'CO'" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="60" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="32" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixlen" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="5" ActualEndOfScans="5" ActualExecutions="5" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixlen" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</DefinedValue>
</DefinedValues>
<Object Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Index="[datatypeinfoclust]" Alias="[d]" TableReferenceId="1" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[imeta].[sys].[syscolpars].[xtype] as [c].[xtype]">
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xtype" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="74" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="1.28e-006" AvgRowSize="143" EstimatedTotalSubtreeCost="0.00328438" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="5" ActualExecutions="5" />
</RunTimeInformation>
<Filter StartupExpression="0">
<RelOp NodeId="75" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="147" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="1" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="5" ActualExecutions="5" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="nsid" />
</DefinedValue>
</DefinedValues>
<Object Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Index="[clst]" Alias="[s]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="class" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="(27)">
<Const ConstValue="(27)" />
</ScalarOperator>
<ScalarOperator ScalarString="[imeta].[sys].[syscolpars].[xmlns] as [c].[xmlns]">
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="xmlns" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[imeta].[sys].[sysnsobjs].[nsid] as [s].[nsid]=(4) OR has_access('XC',(0),[imeta].[sys].[sysnsobjs].[id] as [s].[id])=(1)">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="nsid" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="has_access">
<ScalarOperator>
<Const ConstValue="'XC'" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysnsobjs]" Alias="[s]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</NestedLoops>
</RelOp>
<RelOp NodeId="77" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="4145" EstimatedTotalSubtreeCost="0.00657136" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="schid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="name" />
<ColumnReference Column="Expr1073" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="5" ActualExecutions="5" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<RelOp NodeId="78" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="235" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="5" ActualExecutions="5" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues />
<Object Database="[imeta]" Schema="[sys]" Table="[syssingleobjrefs]" Index="[clst]" Alias="[r]" TableReferenceId="3" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syssingleobjrefs]" Alias="[r]" Column="depid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syssingleobjrefs]" Alias="[r]" Column="class" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syssingleobjrefs]" Alias="[r]" Column="depsubid" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[imeta].[sys].[syscolpars].[utype] as [c].[utype]">
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(38)">
<Const ConstValue="(38)" />
</ScalarOperator>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<RelOp NodeId="79" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="4145" EstimatedTotalSubtreeCost="0.00328408" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="schid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="name" />
<ColumnReference Column="Expr1073" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1073" />
<ScalarOperator ScalarString="CONVERT(nvarchar(4000),CONVERT(nvarchar(4000),typepropertyex([imeta].[sys].[sysscalartypes].[id] as [t].[id],'assembly_qualified_name'),0),0)">
<Convert DataType="nvarchar" Length="8000" Style="0" Implicit="0">
<ScalarOperator>
<Convert DataType="nvarchar" Length="8000" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="typepropertyex">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'assembly_qualified_name'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="80" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="8.8e-007" AvgRowSize="147" EstimatedTotalSubtreeCost="0.00328398" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="schid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<Filter StartupExpression="0">
<RelOp NodeId="81" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="147" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="34" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="schid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="name" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="schid" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="name" />
</DefinedValue>
</DefinedValues>
<Object Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Index="[clst]" Alias="[t]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[imeta].[sys].[syscolpars].[utype] as [c].[utype]">
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[syscolpars]" Alias="[c]" Column="utype" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="has_access('UT',[imeta].[sys].[sysscalartypes].[id] as [t].[id])=(1)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="has_access">
<ScalarOperator>
<Const ConstValue="'UT'" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysscalartypes]" Alias="[t]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</ComputeScalar>
</RelOp>
</NestedLoops>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="125" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="8571" EstimatedTotalSubtreeCost="0.0285343" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Column="Expr1161" />
<ColumnReference Column="Expr1162" />
<ColumnReference Column="Expr1163" />
<ColumnReference Column="Expr1164" />
<ColumnReference Column="Expr1165" />
<ColumnReference Column="Expr1166" />
<ColumnReference Column="Expr1167" />
<ColumnReference Column="Expr1168" />
<ColumnReference Column="Expr1172" />
<ColumnReference Column="Expr1173" />
<ColumnReference Column="Expr1176" />
<ColumnReference Column="Expr1179" />
<ColumnReference Column="Expr1180" />
<ColumnReference Column="Expr1181" />
<ColumnReference Column="Expr1183" />
<ColumnReference Column="Expr1186" />
<ColumnReference Column="Expr1189" />
<ColumnReference Column="Expr1192" />
<ColumnReference Column="Expr1195" />
<ColumnReference Column="Expr1200" />
<ColumnReference Column="Expr1201" />
<ColumnReference Column="Expr1202" />
<ColumnReference Column="Expr1203" />
<ColumnReference Column="Expr1204" />
<ColumnReference Column="Expr1207" />
<ColumnReference Column="Expr1210" />
<ColumnReference Column="Expr1211" />
<ColumnReference Column="Expr1214" />
<ColumnReference Column="Expr1215" />
<ColumnReference Column="Expr1216" />
<ColumnReference Column="Expr1217" />
<ColumnReference Column="Expr1218" />
<ColumnReference Column="Expr1219" />
<ColumnReference Column="Expr1220" />
<ColumnReference Column="Expr1221" />
<ColumnReference Column="Expr1222" />
<ColumnReference Column="Expr1223" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1161" />
<ScalarOperator ScalarString="db_name()">
<Identifier>
<ColumnReference Column="ConstExpr1314">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1163" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1164" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1168" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[is_long] as [d].[is_long]=(1) OR [mssqlsystemresource].[sys].[syscolpars].[length]=(-1) THEN (130) ELSE (0) END|[Expr1342]|[Expr1343]|CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(189) THEN (512) ELSE CASE WHEN (0)&lt;&gt;(1) AND has_perms_by_name(quotename(schema_name([imeta].[sys].[sysschobjs].[nsid] as [o].[nsid]))+N'.'+quotename([imeta].[sys].[sysschobjs].[name] as [o].[name]),N'OBJECT',N'UPDATE',quotename(CONVERT(nvarchar(128),[mssqlsystemresource].[sys].[syscolpars].[name],0)),N'COLUMN')=(1) THEN (4) ELSE (0) END END|[Expr1344]">
<Arithmetic Operation="BIT_OR">
<ScalarOperator>
<Arithmetic Operation="BIT_OR">
<ScalarOperator>
<Arithmetic Operation="BIT_OR">
<ScalarOperator>
<Arithmetic Operation="BIT_OR">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1342" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1343" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(189)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(512)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="NE">
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="has_perms_by_name">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'.'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'OBJECT'" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'UPDATE'" />
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'COLUMN'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="Expr1344" />
</Identifier>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1172" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1173" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(128) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN isnull([mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size],CASE WHEN [mssqlsystemresource].[sys].[syscolpars].[length]=(-1) THEN (0) ELSE CONVERT_IMPLICIT(int,[mssqlsystemresource].[sys].[syscolpars].[length],0) END) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) THEN CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size] IS NOT NULL THEN [mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size] ELSE CONVERT_IMPLICIT(int,[mssqlsystemresource].[sys].[syscolpars].[length],0)/(2) END ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(132) AND [mssqlsystemresource].[sys].[syscolpars].[length]=(-1) THEN (0) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(132) THEN CONVERT_IMPLICIT(int,[mssqlsystemresource].[sys].[syscolpars].[length],0) ELSE NULL END END END END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(128)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Arithmetic Operation="DIV">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(132)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(132)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1176" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(128) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN isnull([mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size],CASE WHEN [mssqlsystemresource].[sys].[syscolpars].[length]=(-1) THEN (0) ELSE CONVERT_IMPLICIT(int,[mssqlsystemresource].[sys].[syscolpars].[length],0) END) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) THEN isnull([mssqlsystemresource].[sys].[spt_provider_types].[column_size] as [d].[column_size]*(2),CASE WHEN [mssqlsystemresource].[sys].[syscolpars].[length]=(-1) THEN (0) ELSE CONVERT_IMPLICIT(int,[mssqlsystemresource].[sys].[syscolpars].[length],0) END) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(132) AND [mssqlsystemresource].[sys].[syscolpars].[length]=(-1) THEN (0) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(132) THEN CONVERT_IMPLICIT(int,[mssqlsystemresource].[sys].[syscolpars].[length],0) ELSE NULL END END END END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(128)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="isnull">
<ScalarOperator>
<Arithmetic Operation="MULT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(2)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(132)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(-1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(132)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1179" />
<ScalarOperator ScalarString="CONVERT(smallint,CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(131) THEN CONVERT_IMPLICIT(int,[mssqlsystemresource].[sys].[syscolpars].[prec],0) ELSE CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[fixed_prec_scale] as [d].[fixed_prec_scale]=(1) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(4) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(5) THEN [mssqlsystemresource].[sys].[spt_provider_types].[data_precision] as [d].[data_precision] ELSE NULL END END,0)">
<Convert DataType="smallint" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(131)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="prec" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(4)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(5)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
</Identifier>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1180" />
<ScalarOperator ScalarString="CONVERT(smallint,CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(131) THEN odbcscale([mssqlsystemresource].[sys].[syscolpars].[xtype],[mssqlsystemresource].[sys].[syscolpars].[scale]) ELSE NULL END,0)">
<Convert DataType="smallint" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(131)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="odbcscale">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="scale" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1181" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(43) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(42) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(41) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(40) THEN CONVERT_IMPLICIT(int,[mssqlsystemresource].[sys].[syscolpars].[scale],0) ELSE [mssqlsystemresource].[sys].[spt_provider_types].[datetime_precision] as [d].[datetime_precision] END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(43)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(42)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(41)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(40)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="1">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="scale" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1189" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN collationproperty(CONVERT(nvarchar(128),columnpropertyex([mssqlsystemresource].[sys].[syscolpars].[id],[mssqlsystemresource].[sys].[syscolpars].[name],'collation'),0),'sqlcharsetname') ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Intrinsic FunctionName="collationproperty">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="columnpropertyex">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'collation'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'sqlcharsetname'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1200" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[syscolpars].[utype]&lt;(256) THEN NULL ELSE db_name() END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(256)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1321">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1201" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[syscolpars].[utype]&lt;(256) THEN NULL ELSE schema_name([imeta].[sys].[sysschobjs].[nsid] as [o].[nsid]) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(256)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1203" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1210" />
<ScalarOperator ScalarString="CASE WHEN CONVERT(int,databasepropertyex(db_name(),'sqlsortorder'),0)=(0) THEN NULL ELSE CONVERT(int,databasepropertyex(db_name(),'sqlsortorder'),0) END">
<Identifier>
<ColumnReference Column="ConstExpr1328">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="databasepropertyex">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'sqlsortorder'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Convert DataType="int" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="databasepropertyex">
<ScalarOperator>
<Intrinsic FunctionName="db_name">
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'sqlsortorder'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1215" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1216" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1217" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1218" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1219" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1220" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1221" />
<ScalarOperator ScalarString="NULL">
<Const ConstValue="NULL" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1222" />
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1223" />
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="126" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="3377" EstimatedTotalSubtreeCost="0.0285342" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="prec" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="scale" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
<ColumnReference Column="Expr1162" />
<ColumnReference Column="Expr1165" />
<ColumnReference Column="Expr1166" />
<ColumnReference Column="Expr1167" />
<ColumnReference Column="Expr1183" />
<ColumnReference Column="Expr1186" />
<ColumnReference Column="Expr1192" />
<ColumnReference Column="Expr1195" />
<ColumnReference Column="Expr1202" />
<ColumnReference Column="Expr1204" />
<ColumnReference Column="Expr1207" />
<ColumnReference Column="Expr1211" />
<ColumnReference Column="Expr1214" />
<ColumnReference Column="Expr1342" />
<ColumnReference Column="Expr1343" />
<ColumnReference Column="Expr1344" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1183" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN N'master' ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="N'master'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1186" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN N'dbo' ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="N'dbo'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1192" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN N'master' ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="N'master'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1195" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(130) OR [mssqlsystemresource].[sys].[spt_provider_types].[oledb_data_type] as [d].[oledb_data_type]=(129) THEN N'dbo' ELSE NULL END,0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(130)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(129)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="N'dbo'" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1342" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[fixlen] as [d].[fixlen] IS NOT NULL THEN (16) ELSE (0) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="IS NOT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixlen" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(16)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1344" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(43) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(42) OR [mssqlsystemresource].[sys].[spt_provider_types].[ss_dtype] as [d].[ss_dtype]=(41) THEN (1073741824) ELSE (0) END">
<IF>
<Condition>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(43)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(42)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(41)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(1073741824)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="127" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="2852" EstimatedTotalSubtreeCost="0.0285341" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="prec" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="scale" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixlen" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
<ColumnReference Column="Expr1162" />
<ColumnReference Column="Expr1165" />
<ColumnReference Column="Expr1166" />
<ColumnReference Column="Expr1167" />
<ColumnReference Column="Expr1202" />
<ColumnReference Column="Expr1204" />
<ColumnReference Column="Expr1207" />
<ColumnReference Column="Expr1211" />
<ColumnReference Column="Expr1214" />
<ColumnReference Column="Expr1343" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
</OuterReferences>
<RelOp NodeId="128" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="2832" EstimatedTotalSubtreeCost="0.0252468" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="prec" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="scale" />
<ColumnReference Column="Expr1135" />
<ColumnReference Column="Expr1151" />
<ColumnReference Column="Expr1152" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Column="Expr1162" />
<ColumnReference Column="Expr1165" />
<ColumnReference Column="Expr1166" />
<ColumnReference Column="Expr1167" />
<ColumnReference Column="Expr1202" />
<ColumnReference Column="Expr1204" />
<ColumnReference Column="Expr1207" />
<ColumnReference Column="Expr1211" />
<ColumnReference Column="Expr1214" />
<ColumnReference Column="Expr1343" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1135" />
<ScalarOperator ScalarString="CONVERT(bit,(1)-([mssqlsystemresource].[sys].[syscolpars].[status]&amp;(1)),0)">
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="SUB">
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1151" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),[mssqlsystemresource].[sys].[syscolpars].[name],0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1152" />
<ScalarOperator ScalarString="CONVERT(nvarchar(128),columnpropertyex([mssqlsystemresource].[sys].[syscolpars].[id],[mssqlsystemresource].[sys].[syscolpars].[name],'collation'),0)">
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="columnpropertyex">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'collation'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1165" />
<ScalarOperator ScalarString="columnproperty([mssqlsystemresource].[sys].[syscolpars].[id],CONVERT(nvarchar(128),[mssqlsystemresource].[sys].[syscolpars].[name],0),'ordinal')">
<Intrinsic FunctionName="columnproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'ordinal'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1166" />
<ScalarOperator ScalarString="CONVERT(bit,CASE WHEN columnproperty([mssqlsystemresource].[sys].[syscolpars].[id],CONVERT(nvarchar(128),[mssqlsystemresource].[sys].[syscolpars].[name],0),'default')=(0) THEN (0) ELSE (1) END,0)">
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="columnproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'default'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1167" />
<ScalarOperator ScalarString="CONVERT(nvarchar(2000),object_definition(columnproperty([mssqlsystemresource].[sys].[syscolpars].[id],CONVERT(nvarchar(128),[mssqlsystemresource].[sys].[syscolpars].[name],0),'default')),0)">
<Convert DataType="nvarchar" Length="4000" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="object_definition">
<ScalarOperator>
<Intrinsic FunctionName="columnproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'default'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1202" />
<ScalarOperator ScalarString="CASE WHEN [mssqlsystemresource].[sys].[syscolpars].[utype]&lt;(256) THEN NULL ELSE type_name([mssqlsystemresource].[sys].[syscolpars].[utype]) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="LT">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(256)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Intrinsic FunctionName="type_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1204" />
<ScalarOperator ScalarString="CONVERT(int,collationproperty(CONVERT(nvarchar(128),columnpropertyex([mssqlsystemresource].[sys].[syscolpars].[id],[mssqlsystemresource].[sys].[syscolpars].[name],'collation'),0),'lcid'),0)">
<Convert DataType="int" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationproperty">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="columnpropertyex">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'collation'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'lcid'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1207" />
<ScalarOperator ScalarString="CONVERT(int,collationproperty(CONVERT(nvarchar(128),columnpropertyex([mssqlsystemresource].[sys].[syscolpars].[id],[mssqlsystemresource].[sys].[syscolpars].[name],'collation'),0),'oledbcompstyle'),0)">
<Convert DataType="int" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationproperty">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="columnpropertyex">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'collation'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'oledbcompstyle'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1211" />
<ScalarOperator ScalarString="CONVERT(binary(5),collationproperty(CONVERT(nvarchar(128),columnpropertyex([mssqlsystemresource].[sys].[syscolpars].[id],[mssqlsystemresource].[sys].[syscolpars].[name],'collation'),0),'TDSCollation'),0)">
<Convert DataType="binary" Length="5" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="collationproperty">
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="columnpropertyex">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'collation'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'TDSCollation'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1214" />
<ScalarOperator ScalarString="CONVERT(bit,columnproperty([mssqlsystemresource].[sys].[syscolpars].[id],CONVERT(nvarchar(128),[mssqlsystemresource].[sys].[syscolpars].[name],0),'IsComputed'),0)">
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Intrinsic FunctionName="columnproperty">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'IsComputed'" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Convert>
</ScalarOperator>
</DefinedValue>
<DefinedValue>
<ColumnReference Column="Expr1343" />
<ScalarOperator ScalarString="CASE WHEN CONVERT(bit,(1)-([mssqlsystemresource].[sys].[syscolpars].[status]&amp;(1)),0)=(1) THEN (96) ELSE (0) END">
<IF>
<Condition>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Convert DataType="bit" Style="0" Implicit="0">
<ScalarOperator>
<Arithmetic Operation="SUB">
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
</Convert>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Condition>
<Then>
<ScalarOperator>
<Const ConstValue="(96)" />
</ScalarOperator>
</Then>
<Else>
<ScalarOperator>
<Const ConstValue="(0)" />
</ScalarOperator>
</Else>
</IF>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="129" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1" EstimateIO="0" EstimateCPU="4.18e-006" AvgRowSize="421" EstimatedTotalSubtreeCost="0.0252467" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="prec" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="status" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Column="Expr1162" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</OuterReferences>
<RelOp NodeId="130" PhysicalOp="Compute Scalar" LogicalOp="Compute Scalar" EstimateRows="1" EstimateIO="0" EstimateCPU="1e-007" AvgRowSize="277" EstimatedTotalSubtreeCost="0.021952" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Column="Expr1162" />
</OutputList>
<ComputeScalar>
<DefinedValues>
<DefinedValue>
<ColumnReference Column="Expr1162" />
<ScalarOperator ScalarString="schema_name([imeta].[sys].[sysschobjs].[nsid] as [o].[nsid])">
<Intrinsic FunctionName="schema_name">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</Identifier>
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</DefinedValue>
</DefinedValues>
<RelOp NodeId="131" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="2.52034e-006" AvgRowSize="147" EstimatedTotalSubtreeCost="0.0219519" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Filter StartupExpression="0">
<RelOp NodeId="132" PhysicalOp="Nested Loops" LogicalOp="Inner Join" EstimateRows="1.5002" EstimateIO="0" EstimateCPU="6.27085e-006" AvgRowSize="149" EstimatedTotalSubtreeCost="0.0219494" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<NestedLoops Optimized="0">
<OuterReferences>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</OuterReferences>
<RelOp NodeId="133" PhysicalOp="Sort" LogicalOp="Distinct Sort" EstimateRows="1.5002" EstimateIO="0.0112613" EstimateCPU="0.000103267" AvgRowSize="147" EstimatedTotalSubtreeCost="0.0179321" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<MemoryFractions Input="0.333333" Output="0.333333" />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Sort Distinct="1">
<OrderBy>
<OrderByColumn Ascending="1">
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</OrderByColumn>
</OrderBy>
<RelOp NodeId="134" PhysicalOp="Concatenation" LogicalOp="Concatenation" EstimateRows="2" EstimateIO="0" EstimateCPU="2e-007" AvgRowSize="147" EstimatedTotalSubtreeCost="0.00656756" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Concat>
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</DefinedValue>
</DefinedValues>
<RelOp NodeId="135" PhysicalOp="Filter" LogicalOp="Filter" EstimateRows="1" EstimateIO="0" EstimateCPU="2.8e-007" AvgRowSize="147" EstimatedTotalSubtreeCost="0.00328338" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualRebinds="1" ActualRewinds="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<Filter StartupExpression="1">
<RelOp NodeId="136" PhysicalOp="Index Seek" LogicalOp="Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="147" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2462" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</DefinedValue>
</DefinedValues>
<Object Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Index="[nc2]" Alias="[o]" TableReferenceId="2" IndexKind="NonClustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[@table_name]">
<Identifier>
<ColumnReference Column="@table_name" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="[@table_schema] IS NULL">
<Identifier>
<ColumnReference Column="ConstExpr1332">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@table_schema" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
<RelOp NodeId="138" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="149" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="2462" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="1" ActualExecutions="1" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="nsid" />
</DefinedValue>
</DefinedValues>
<Object Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Index="[clst]" Alias="[o]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="object_id(quotename([@table_schema])+N'.'+quotename([@table_name]))">
<Identifier>
<ColumnReference Column="ConstExpr1333">
<ScalarOperator>
<Intrinsic FunctionName="object_id">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Arithmetic Operation="ADD">
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@table_schema" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="N'.'" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Intrinsic FunctionName="quotename">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@table_name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[type] as [o].[type]='S' OR [imeta].[sys].[sysschobjs].[type] as [o].[type]='V'">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'S'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'V'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</Concat>
</RelOp>
</Sort>
</RelOp>
<RelOp NodeId="140" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="9" EstimatedTotalSubtreeCost="0.00401106" TableCardinality="2462" Parallel="0" EstimateRebinds="0.500203" EstimateRewinds="2.21924e-016" EstimatedExecutionMode="Row">
<OutputList />
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Lookup="1" Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues />
<Object Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Index="[clst]" Alias="[o]" TableReferenceId="-1" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[id] as [o].[id]">
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[type] as [o].[type]='S' OR [imeta].[sys].[sysschobjs].[type] as [o].[type]='V'">
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'S'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="type" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="'V'" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
<Predicate>
<ScalarOperator ScalarString="has_access('SO',[imeta].[sys].[sysschobjs].[id] as [o].[id])=(1)">
<Compare CompareOp="EQ">
<ScalarOperator>
<Intrinsic FunctionName="has_access">
<ScalarOperator>
<Const ConstValue="'SO'" />
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="" />
</ScalarOperator>
</Intrinsic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(1)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</Predicate>
</Filter>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="146" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.000160772" AvgRowSize="156" EstimatedTotalSubtreeCost="0.00328577" TableCardinality="22537" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="prec" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="status" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="utype" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="length" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="prec" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="scale" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="status" />
</DefinedValue>
</DefinedValues>
<Object Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Index="[clst]" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="id" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="number" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[imeta].[sys].[sysschobjs].[id] as [o].[id]">
<Identifier>
<ColumnReference Database="[imeta]" Schema="[sys]" Table="[sysschobjs]" Alias="[o]" Column="id" />
</Identifier>
</ScalarOperator>
<ScalarOperator ScalarString="(0)">
<Const ConstValue="(0)" />
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
<Predicate>
<ScalarOperator ScalarString="([mssqlsystemresource].[sys].[syscolpars].[status]&amp;(4096))=(4096) AND ([@column_name]=CONVERT(nvarchar(128),[mssqlsystemresource].[sys].[syscolpars].[name],0) OR [@column_name] IS NULL)">
<Logical Operation="AND">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Arithmetic Operation="BIT_AND">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="status" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(4096)" />
</ScalarOperator>
</Arithmetic>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="(4096)" />
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Logical Operation="OR">
<ScalarOperator>
<Compare CompareOp="EQ">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@column_name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Convert DataType="nvarchar" Length="256" Style="0" Implicit="0">
<ScalarOperator>
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="name" />
</Identifier>
</ScalarOperator>
</Convert>
</ScalarOperator>
</Compare>
</ScalarOperator>
<ScalarOperator>
<Identifier>
<ColumnReference Column="ConstExpr1334">
<ScalarOperator>
<Compare CompareOp="IS">
<ScalarOperator>
<Identifier>
<ColumnReference Column="@column_name" />
</Identifier>
</ScalarOperator>
<ScalarOperator>
<Const ConstValue="NULL" />
</ScalarOperator>
</Compare>
</ScalarOperator>
</ColumnReference>
</Identifier>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Logical>
</ScalarOperator>
</Predicate>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
<RelOp NodeId="172" PhysicalOp="Clustered Index Seek" LogicalOp="Clustered Index Seek" EstimateRows="1" EstimateIO="0.003125" EstimateCPU="0.0001581" AvgRowSize="27" EstimatedTotalSubtreeCost="0.0032831" TableCardinality="32" Parallel="0" EstimateRebinds="0" EstimateRewinds="0" EstimatedExecutionMode="Row">
<OutputList>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixlen" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</OutputList>
<RunTimeInformation>
<RunTimeCountersPerThread Thread="0" ActualRows="0" ActualEndOfScans="0" ActualExecutions="0" />
</RunTimeInformation>
<IndexScan Ordered="1" ScanDirection="FORWARD" ForcedIndex="0" ForceSeek="0" ForceScan="0" NoExpandHint="0" Storage="RowStore">
<DefinedValues>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixlen" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="oledb_data_type" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="fixed_prec_scale" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="is_long" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="data_precision" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="datetime_precision" />
</DefinedValue>
<DefinedValue>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="column_size" />
</DefinedValue>
</DefinedValues>
<Object Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Index="[datatypeinfoclust]" Alias="[d]" TableReferenceId="2" IndexKind="Clustered" Storage="RowStore" />
<SeekPredicates>
<SeekPredicateNew>
<SeekKeys>
<Prefix ScanType="EQ">
<RangeColumns>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[spt_provider_types]" Alias="[d]" Column="ss_dtype" />
</RangeColumns>
<RangeExpressions>
<ScalarOperator ScalarString="[mssqlsystemresource].[sys].[syscolpars].[xtype]">
<Identifier>
<ColumnReference Database="[mssqlsystemresource]" Schema="[sys]" Table="[syscolpars]" Column="xtype" />
</Identifier>
</ScalarOperator>
</RangeExpressions>
</Prefix>
</SeekKeys>
</SeekPredicateNew>
</SeekPredicates>
</IndexScan>
</RelOp>
</NestedLoops>
</RelOp>
</ComputeScalar>
</RelOp>
</ComputeScalar>
</RelOp>
</Concat>
</RelOp>
</Sort>
</RelOp>
<ParameterList>
<ColumnReference Column="@column_name" ParameterCompiledValue="NULL" ParameterRuntimeValue="NULL" />
<ColumnReference Column="@table_name" ParameterCompiledValue="N'obj_param_val'" ParameterRuntimeValue="N'param'" />
<ColumnReference Column="@table_schema" ParameterCompiledValue="N'dbo'" ParameterRuntimeValue="N'dbo'" />
</ParameterList>
</QueryPlan>
</StmtSimple>
</Statements>
</Batch>
</BatchSequence>
</ShowPlanXML>
</value>
</data>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment