MSSQL: Query to display objects in a database
Filed in SQL on Jun.28, 2007
This t-sql query will list names of sql objects and its type:
SELECT
name,
CASE WHEN type='P' THEN
'Stored Procedure'
ELSE
CASE WHEN type='TR' THEN
'Trigger'
ELSE CASE WHEN type='V' THEN
'View'
ELSE CASE WHEN type='U' THEN
'Table'
ELSE CASE WHEN type='FN' THEN
'Function'
ELSE CASE WHEN type='F' THEN
'Foregin Key'
ELSE CASE WHEN type='K' THEN
'Key'
END
END
END
END
END
END
END
FROM
sysObjects
WHERE
type='P' or type='TR' or type='V' or type='U' or type='FN' or type='F' or type='K'
ORDER BY
type, name
Related posts:
