how to set a table column's as primary key in SNow
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2021 08:32 AM
2 REPLIES 2
Community Alums
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2021 12:26 PM
Sys ID is Primary key for most of all tables. I would not change the Primary key for any of the OOB tables.
If you want to set for your custom tables then there's a Primary (true/false) field.
Open the table definition, add Primary field to the form and set it for desired field for your table.
Community Alums
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-18-2021 12:31 PM
Or you can set the field Unique = true from Dictionary of the table