-- SQL Server 2008, SQL Server 2005

SELECT * FROM sys.objects WHERE name='FK_Produse_UnitatiDeMasura';

-- SQL Server 2000

SELECT * FROM sysobjects WHERE name='FK_Produse_UnitatiDeMasura';

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro