您可以使用以下脚本生成所有权限

SELECT CONCAT(
    CASE WHEN p.state = 'W' THEN 'GRANT' ELSE p.state_desc END,
    ' ',
    p.permission_name,
    ' ON '
    QUOTENAME(s.name),
    '.',
    QUOTENAME(t.name),
    '(' + QUOTENAME(c.name) + ')',    -- The + feeds through nulls
    ' TO ',
    QUOTENAME(dp.name),
    CASE WHEN p.state = 'W' THEN ' WITH GRANT OPTION' END,
    ';'
  )
FROM sys.database_permissions p
JOIN sys.database_principals dp ON dp.principal_id = p.grantor_principal_id
JOIN sys.tables t ON t.object_id = p.major_id
JOIN sys.schemas s ON s.schema_id = t.schema_id
LEFT JOIN sys.columns c ON c.object_id = t.object_id
    AND c.column_id = p.minor_id
    AND p.minor_id <> 0
WHERE t.name = 'YourTable';

可以使用不同的系统视图以类似的方式完成约束，但不清楚您具体询问的是哪些约束。