Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

Fabric Warehouse - Support for OBJECTPROPERTYEX (object_id, 'Cardinality')

Hi Product Team,

 

In SQL Server, the fastest way to get a row count from a set of tables is shown below.  Unfortunately, the wrong aswer is coming back, zero records.

 

i4.png

 

If we look use a SELECT statement, we get the correct row count.

 

i5.png

The statement is supported in TSQL for MS Fabric Warehouse but does not work correctly.

 

Sincerely

 

John Miner

Data Platform MVP

 

i1.png

Status: New