autofix and other utilities sql server.sql

autofix_and_other_utilities_sql_server.sql

EXEC sp_change_users_login 'Auto_Fix', 'user', NULL, 'pass'

-- constraints information
SELECT * FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT'

SELECT *
 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
 where CONSTRAINT_NAME = 'constraint_name'

SELECT OBJECT_NAME(object_id) AS ConstraintName,
SCHEMA_NAME(schema_id) AS SchemaName,
type_desc AS ConstraintType
FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT' AND OBJECT_NAME(parent_object_id)='constraint_nem'

--constraints from a table
exec sp_helpconstraint 'table_name'