(unbekannte) Constraint löschen?!

[marabu]

Hallo Shivan,

aus einem Artikel eines anderen Forums:

SQL-Code:

CREATE PROCEDURE [DBO].[GetConstraintName] (
  @tablename sysname,
  @columnName sysname,
  @constraintName sysname OUTPUT
) AS
SELECT @constraintName = o1.name
FROM sysobjects o1
INNER JOIN syscolumns c ON o1.id = c.cdefault
INNER JOIN sysobjects o2 ON o1.parent_obj = o2.id
WHERE (o2.name = @tablename) AND (c.name = @columnName)

Grüße vom marabu