I am partitioning one of the tables in my database.
Lets say I have a global company with employees in multiple countries.
country is a FK in Employee table.
I have already created the partition function, partition scheme and file group.
Employee table looks like this:
CREATE TABLE [dbo].[Employee](
[Emp_ID] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
[Emp_Num] [int] NOT NULL,
[Type] [nvarchar](10) NULL,
[Quarter] [int] NULL),
CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
How can I add below line to the create table query above?
Thanks in advance