Is it possible to see which indexes on a table are unique?

[Antony Morling1]

I am trying to find out if a specific table (sn_customerservice_contact_relationship) has a unique index defined.

[Runjay Patel · Accepted solution]

Hi @Antony Morling1 ,

Follow below steps.

1. Go to System Definition > Tables.
2. Search for the table sn_customerservice_contact_relationship and open it.
3. Scroll down to the Indexes related list (ensure the related list is enabled for the table form).
4. If you find one, it means the table has a unique index defined.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[poyntzj]

Surely that is just showing the indexes, not if the index is unique/coalese

[Community Alums]

Hi @Antony Morling1 and @poyntzj ,

Unique index you will need to create, follow the below steps:

Steps to follow in order to create a Table Index:

1. Navigate to: System Definition ➔ Tables
2. Search and access the table on which you want to create the index.
3. Navigate to the 'Database Indexes' related list.
4. Click on 'New'.
5. In the Index Name field, type a name for your index.
6. 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.
7. To create a unique index, check the 'Unique Index' check box.
8. Click on the 'Create Index' UI Action.

[cori10]

the related list on the Table form is v_index_creator, which doesn't include a column specifying if the index is unique - but if you look for the index on the sys_index table, you'll see a 'Unique Index' true/false column