Concerning constraints (SQL Server 2k8)

Showing constraints in SA message window:

Code:

$PROMPT(type,Constraint type?,,Parameter for View Constraints macro,% PK F UQ TR C D,All "Primary Key" "Foreign Key" "Unique Key" Trigger Check Default)$

$$
SELECT
s.[schema_id]
,s.[name] AS [schema_name]
   ,t.[object_id] AS table_id
   ,t.[name] AS table_name
   ,con.[object_id] AS constraint_id
   ,con.[name] AS constraint_name
   ,con.[type]
   ,con.type_desc

FROM
sys.schemas s
INNER JOIN
sys.tables t
ON t.[schema_id] = s.[schema_id]
INNER JOIN
sys.objects con
ON con.parent_object_id = t.[object_id]
WHERE con.[type] LIKE '$type$'
AND t.[object_id] = OBJECT_ID('$OBJECT$')
$$

Creating a drop script for constraints:

Code:

$PROMPT(type,Constraint type?,,,% PK F UQ TR C D,All "Primary Key" "Foreign Key" "Unique Key" Trigger Check Default)$
$$
DECLARE @sql NVARCHAR(MAX) = ''

SELECT @sql = @sql
+ 'ALTER TABLE $OBJECT$ DROP CONSTRAINT ' + con.[name] + CHAR(10) + 'GO' + CHAR(10)
FROM
sys.schemas s
INNER JOIN
sys.tables t
ON t.[schema_id] = s.[schema_id]
INNER JOIN
sys.objects con
ON con.parent_object_id = t.[object_id]
WHERE con.[type] LIKE '$type$'
AND t.[object_id] = OBJECT_ID('$OBJECT$')

SELECT @sql
$$

Another one for disabling/dropping triggers:

Code:

$PROMPT(dtrig,Disable or Drop?,,,DISABLE ENABLE DROP )$
$$
DECLARE @sql NVARCHAR(MAX) = ''

SELECT
@sql += 'ALTER TABLE $OBJECT$ '
+ CASE '$dtrig$'
   WHEN 'DISABLE' THEN 'DISABLE TRIGGER '
   WHEN 'ENABLE' THEN 'ENABLE TRIGGER '
   WHEN 'DROP' THEN 'DROP CONSTRAINT '
   END
+ QUOTENAME( con.name ) + CHAR( 10 ) + 'GO' + CHAR( 10 )
FROM
sys.schemas s
INNER JOIN
sys.tables t
   ON t.[schema_id] = s.[schema_id]
INNER JOIN
sys.objects con
   ON con.parent_object_id = t.[object_id]
WHERE con.[type] = 'TR'
AND t.[object_id] = OBJECT_ID( '$OBJECT$' )
SELECT @sql
$$