:::: MENU ::::

Included columns in SQL Server 2005

  • Nov 15 / 2008
  • 0
Data Modeling and Database Design, Data Types, dbDigger

Included columns in SQL Server 2005

Question: What are included columns?

Answer:

  • A new feature in SQL Server 2005
  • Non key columns included in addition to the index key columns in an index structure.

Explanation: In SQL Server 2005, a nonclustered index can be extended by including nonkey columns in addition to the index key columns. The nonkey columns are stored at the leaf level of the index b-tree.

You can read detail at –

Note: The Question is taken from SQLServercentral.com.

Consult us to explore the Databases. Contact us