I am using SQL Server Developer 14. I am pretty new to SQL Server.
I was working on the indexes for a table in the SQL DB. I added a new index and wanted to delete one that was no longer needed. Instead of deleting the index I intended, I deleted the PrimaryKey index,, which was on the Indentity column (PayRecID) of the table.
I recreated a clustered, unique index to replace the Primary Key index but I'm not sure if that is sufficient. I don't see anything in the available options to create a Primary Index on a table.
How can I create a Primary index on the table for column PayRecID?