Friday, March 2, 2012

which objects belong to a specific schema

SELECT name, object_id, type_desc
FROM sys.objects
WHERE OBJECTPROPERTY(object_id, N'SchemaId') = SCHEMA_ID(N'George')
ORDER BY type_desc, name;

No comments:

Post a Comment