I have one table:
CREATE TABLE [dbo].[entry] ( [ID] [bigint] IDENTITY(1,1) NOT NULL, [EntryDate] [datetime] NOT NULL, [createddate] [datetime] NOT NULL, CONSTRAINT [PK_Entry_ID] PRIMARY KEY CLUSTERED ( [ID] ASC ) WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80 ) ON [PRIMARY] ) ON [PRIMARY];
...where the primary key is referenced by another table. To partition this table I have already done following steps :
CREATE PARTITION FUNCTION EntryFunc (DATE) AS RANGE LEFT FOR VALUES ('2011-01-01') CREATE PARTITION SCHEME EntryScheme AS PARTITION EntryFunc TO ([FileGroup2], [PRIMARY])
The above 2 steps successfully completed,but when I am partitioning table I am not able to drop primary key clustered index because it is referenced by other table. My motive is to partition the table Entry according to created date.