Create Table Index

SET NOCOUNT OFF
USE MegaCenter
IF EXISTS (SELECT name FROM sysindexes
WHERE name = 'custid_idx')
DROP INDEX CUST.custid_idx
GO
USE MegaCenter
CREATE INDEX cust1id_idx
ON CUST (CID)
GO