• Hi, thanks for the response.

    The query you gave above did return 'TableA' , and yep i double-checked that 3 times previously too lol.

    I am certain there are no indexes and is indeed a heap table.

    There is one constraint on a column, DEFAULT of newid() on a guid column