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.

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

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

Sincerely

John Miner

Data Platform MVP