You are the database administrator for your company and manage all your company’s SQL Server 2008 databases.
A production database named Prod1 contains all the product and sales data of the company.
You must create a table named Prod_details to hold detailed data about products manufactured by yourcompany.
Company employees will frequently access data in this table in such a way that you want to create thetable as a partitioned table.
You use the following statements to create the partition function My_pf and the partition scheme My_ps1 :
CREATE PARTITION FUNCTION My_pf (int)
AS RANGE RIGHT FOR VALUES (1, 1000, 2000);
CREATE PARTITION SCHEME My_ps1
AS PARTITION My_pf
TO (FG1, FG2, FG3, FG4);
Which statement should you use to create the Prod_details table as a partitioned table?