SAinCA,
I think this is the code you are referencing from this tip (http://www.mssqltips.com/tip.asp?tip=1112):
-- Table - The base table is stored with the
-- clustered index, so moving the clustered
-- index moves the base table
CREATE CLUSTERED INDEX IDX_ProductID ON dbo.OrdersDetail(ProductID)
ON FG_ReadOnly
GO
If so, you can use the ALTER TABLE command to create or remove the primary keys. Here is an example from SQL Server 2005 Books Online (http://msdn2.microsoft.com/en-us/library/ms190273.aspx):
USE AdventureWorks;
GO
ALTER TABLE Production.TransactionHistoryArchive WITH NOCHECK
ADD CONSTRAINT PK_TransactionHistoryArchive_TransactionID PRIMARY KEY CLUSTERED (TransactionID)
WITH (FILLFACTOR = 75, ONLINE = ON, PAD_INDEX = ON)
GO
If this is not the code you are referencing, please reply back with the code from the tip that you have a question about.
Thank you,
The MSSQLTips.com Team
