Hi @rajesh yadav ,
SQLServer sorting rules only affect columns of character type, for example: char, varchar, text, nchar, nvarchar, ntext, so in the query view sys.columns the sorting rule for non-character fields shows NULL.
Although the database sorting rules can be changed, but it is problematic, because even if the database sorting rules are changed, the sorting rules of the fields in the library table may still be the original, not changed, which in use, there may be problems, so the database sorting rules try not to change at will.
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.