When browsing a Microsoft or Sybase SQL Server database, looking for system objects, use a query of form:

SELECT name FROM sysobjects
WHERE type = '<type>'

where <type> can be one of the following:

C - CHECK constraint D - Default or DEFAULT constraint F - FOREIGN KEY constraint K - PRIMARY KEY or UNIQUE constraint L - Log P - Stored procedure R - Rule RF - Stored procedure for replication S - System table TR - Trigger U - User table V - View X - Extended stored procedure