How to create unique index for a field of a tableSummaryThis article provides two different options for creating a unique index for a field of a table. See below for additional information and steps to follow. A unique index on a table guarantees that the index key contains no duplicate values. Specifying a unique index makes sense only when uniqueness is a essential for the data in a table. Using the associated list of indexes for the table, you may both inspect a table's indexes and build your own index for it. Role required: admin It takes expertise in database architecture to build an efficient index. If you don't have this knowledge, we advise that you speak with someone who does.InstructionsOption 1 Navigate to System Definition ➔ Tables & ColumnsSelect a tableThe new form shows up for creating indexesUse the slush bucket to select the field you want to be included in the index.To create a unique index, check the Unique Index box.Click Create Index. Note: With the above procedure, we will not be able to work with partition table like cmdb$par1, indeed follow Procedure#2 Option 2 Navigate to System Definition ➔ Tables.In the list, find the table you want and click its label.Navigate to the Database Indexes related list.Click New.Use the slush bucket to select the fields you want to be included in the index. The order in which you select the fields affects how the index works. If you do not have expertise in database design, we suggest you consult someone who does. To create a unique index, check the Unique Index box.Click Create Index. The Table Name field is there for your reference only. Overriding the default has no effect.Related LinksFor more information about creating a table index, please see the ServiceNow product documentation topic Create a table index.