SELECT OBJECT_NAME(OBJECT_ID) AS NameofConstraint,
SCHEMA_NAME(schema_id) AS SchemaName,
OBJECT_NAME(parent_object_id) AS TableName,
type_desc AS ConstraintType
WHERE type_desc LIKE '%CONSTRAINT'
Directly from the user interface, you cannot. And I'm tempted to say of course. Constraints are bound to an object, and not to the database itself. So, under a table or a view you may look at all the constraints for that specific object. Please note that foreign key constraints and primary key constraints are located under "keys", while other constraints are located under "constraints".