sql server - SQLServer object_id for indices? -
each object in database has own object_id.
we can find listing of objects , object_ids either in sys.objects, or in view specific types (sys.tables, sys.key_contraints, ... ).
now question indices have own object_ids? have found seems not. if not, why not? looks other object (pk,fk, ... ) me. default constraints have own object_id.
thanks clarifications. "internals" question, not trying accomplish in particular, want understand why things are.
indexes unique on (object_id, index_id). of indexes given table have same object_id in sys.indexes, have different index_id.
sql-server internals
No comments:
Post a Comment