Wednesday, 15 September 2010

sql server - SQLServer object_id for indices? -



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