O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Accessing Data Without Indexes: Table Scan

As explained before,table data is stored in pages, and pages are grouped in extents. Special pages called IAM (Index Allocation Map) keep information about which extents are used by a particular table.

Information related to table definition is stored in different system tables:

  • The name of the table, as well as the owner, creation date, and other general information, is stored in the sysobjects system table. The sysobjects table has a field called ID, which provides a unique object identification number for every object stored in a database. The ID field is used to relate this object to extra information in other systems'tables. It is possible to retrieve the table ID calling the OBJECT_ID system function. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required