Partitioned Tables in SQL SERVER
The final step during the process of creating partition is to create the partitioned table.
The below example shows the creation of Partitioned Tables
Create Table Employee(
EmployeeID int PRIMARY KEY,
FirstName varchar(50),
LastName varchar(50),
Sex char(1),
Age int CONSTRAINT df DEFAULT 18,
DateOfBirth DateTime)
ON EmployeePartitionScheme (EmployeeID)
The below example shows the creation of Partitioned Tables
Create Table Employee(
EmployeeID int PRIMARY KEY,
FirstName varchar(50),
LastName varchar(50),
Sex char(1),
Age int CONSTRAINT df DEFAULT 18,
DateOfBirth DateTime)
ON EmployeePartitionScheme (EmployeeID)
Comments