2.2.6.8 UserData View

The UserData View reflects all list items in the AllUserData table (section 2.2.6.2) that are current versions and not marked as deleted (that is, all table rows where tp_IsCurrentVersion is 1, tp_CalculatedVersion is 0, and tp_DeleteTransactionId is 0x).

See AllUserData for the T-SQL syntax description of the structure of this view. Columns defined with the keyword SPARSE do not appear in this view.