When you define a primary key, SSMS will by default make that the clustered index. But if you specifically create a table without a clustered index, you are creating a heap table. SQL Server uses an internal value for referencing rows, but it is not any of your columns. The following may help:
发布评论
评论（2）
当您定义主键时，SSMS 默认情况下会将其设为聚集索引。但是，如果您专门创建一个没有聚集索引的表，那么您正在创建一个堆表。 SQL Server 使用内部值来引用行，但它不是任何列。以下内容可能会有所帮助：
在堆表上，非聚集索引使用什么作为指向行的指针？
http://msdn.microsoft.com/en- us/library/aa964133%28v=sql.90%29.aspx
http://www.mssqltips.com/tip.asp?tip=1254
When you define a primary key, SSMS will by default make that the clustered index. But if you specifically create a table without a clustered index, you are creating a heap table. SQL Server uses an internal value for referencing rows, but it is not any of your columns. The following may help:
On a Heap Table, what does a non-clustered index use as a pointer to a row?
http://msdn.microsoft.com/en-us/library/aa964133%28v=sql.90%29.aspx
http://www.mssqltips.com/tip.asp?tip=1254
您提供的报价是错误的。您可能想阅读一本高质量的书籍，例如 Kalen Delaney 的书：http://www.sqlserverinternals .com/books.html
The quote you are providing is wrong. You might want to read a high quality book, such as a book by Kalen Delaney: http://www.sqlserverinternals.com/books.html