Create a field primary key to access database using c#

// Create with Single Filed

CREATE UNIQUE INDEX myNewIndex ON test (ID) WITH PRIMARY

// Create with Multiple Filed

CREATE UNIQUE INDEX myNewIndex ON test (ID,uname,ut) WITH PRIMARY





// Drop key index

Drop INDEX myNewIndex ON test