sql server 查看表中某一字段的排序规则

SELECT o.name,o.object_id,c.name,c.column_id,c.collation_name   
FROM sys.columns c  
    JOIN sys.objects o  
        ON c.object_id = o.object_id   
WHERE o.object_id = OBJECT_ID('dbo.FileImportMapping')  
    AND c.name = 'OriginalFileId'  

原文地址:https://www.cnblogs.com/mibing/p/8949681.html