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'  

posted @ 2018-04-26 09:50  白羽轻飘  阅读(1077)  评论(0编辑  收藏  举报