What is the page allocation status when SQL Server creates a table?

What is the page allocation status when SQL Server creates a table? Thanks again to the sqlskill website and the person who reproduced and translated the article on the sqlskill website, because your reprinting and translation have helped the younger brother learn the tools used in the article "o (_) o: view the small plug-in InternalsViewer on the internal data page of SQLSERVER. Reference: Before reading it,

What is the page allocation status when SQL Server creates a table? Thanks again to the sqlskill website and the person who reproduced and translated the article on the sqlskill website, because your reprinting and translation have helped the younger brother learn the tools used in the article "o (_) o: view the interinternal Data Page's small plug-in Internals Viewer reference article: Before looking down,

What is the page allocation status when SQL Server creates a table?

Thanks again to the sqlskill website and the person who has reproduced and translated the articles on the sqlskill website, because your reprinting and translation have helped the younger brother learn new things.

Tools used in this article: view the interinternal Data Page's small plug-in Internals Viewer

References:

Before proceeding, please take a look at the interpretation of the hybrid zone and the unified zone. If you do not understand it, you can refer to "SQLSERVER"

Unified zone: it is owned by a single object. All eight pages in the partition can only be used by one object

Hybrid zone: a maximum of 8 objects can be shared. Each page of 8 pages in the partition can be owned by different objects. However, a page can always belong to only one object.

Create four tables: heap table, clustered index table, non-clustered index table, clustered index and non-clustered index table.

Features of these tables: a row of records occupies only one page.

We need to create one, drop the table after analysis, and then create another one, so that we can see it more clearly.

Create Database

1 USE master ALLOCATIONDB ALLOCATIONDB8 GO