MSSQL: Query to display objects in a database #2
Filed in SQL on Jun.28, 2007
Simplified with CASE statement:
SELECT name,
CASE ( TYPE )
WHEN 'P' THEN 'Stored Procedure'
WHEN 'TR' THEN 'Trigger'
WHEN 'V' THEN 'View'
WHEN 'U' THEN 'Table'
WHEN 'FN' THEN 'Function'
WHEN 'F' THEN 'Foregin Key'
WHEN 'K' THEN 'Key'
END AS ObjectType
FROM sysObjects
WHERE type IN ('P','TR','V','U','FN','F','K')
ORDER BY type,
name
Related posts:
