rs_ids

Stores the last ID used for various types of objects.

Column

Datatype

Description

typename

varchar(30)

Name of this object type. For example, “subscriptions,” “objects”

objid

int

Last ID used for this object type

objtype

tinyint

  • Object type:
    • 1 – Subscriptions

    • 2 – Objects

    • 3 – Classes

    • 4 – Users

    • 5 – Functions

    • 6 – Function strings

    • 7 – Error log

  • Exception log types:
    • 12 – Reject transaction

  • Site ID types:
    • 8 – Replication Server ID

    • 9 – Database ID

  • Stable queue parameters:
    • 10 – Disk partition IDs

  • Counter used by subscriptions module:
    • 13 – Counter for subscriptions module

  • Recovery manager IDs:
    • 14 – Recovery ID type

    • 15 – Rematerialization ID

    • 16 – Publication ID

    • 17 – Article ID

    • 18 – where clause ID

    • 19 – UDD ID

Indexes

Unique clustered index on (objtype)