0

Which data type in SQL Server is the correct one for object id in Azure Active Directory?

enter image description here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Dnegelof
  • 1
  • 2

1 Answers1

0

The object id is look like GUID format (Globally Unique Identifier) this GUID is based on machine information in sql server GUID is known by UNIQUEIDENTIFIER data type

So as mentioned by marc you can use UNIQUEIDENTIFIER data type in SQL Server is the correct one for object id in Azure Active Directory

your object id is a base 16-byte number that 491a that four is basically represent what version you are using and yours's Random ID version its claim to uniqueness, if you have two same random id (object id) chances of having collision and it incredibly low so make sure while choosing recheck object id's

Please check this So thread by Manish Kumar Gurjar which worked on the similar thread

To more in detail please refer this link :

Understanding the GUID data type in SQL Server by [Ben Richardson

https://learn.microsoft.com/en-us/sql/t-sql/functions/object-name-transact-sql?view=sql-server-ver16

Imran
  • 3,875
  • 2
  • 3
  • 12
  • Hey, did the suggestion work? do let me know if it solved your problem else share more details so I can troubleshoot. [Help Center -SO](https://stackoverflow.com/help/someone-answers) – Imran Jun 27 '22 at 14:27