2.2.7.8 UserData View

The UserData View reflects all list items in the AllUserData table (section 2.2.7.3) 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 (section 2.2.7.3) for the T-SQL syntax description of the structure of this view.