Curtis Tamanaha
Right there with Babe
Points: 725
More actions
January 31, 2006 at 5:08 pm
#113186
Is there an easy way to find all objects attached to a particular schema.
peterhe
SSChampion
Points: 11469
February 2, 2006 at 7:32 am
#618391
USE
AdventureWorks
GO
SELECT
b.name as schema_name,a.* FROM sys.objects a, sys.schemas b WHERE a.schema_id=b.schema_id and b.name='Person'
February 2, 2006 at 9:39 am
#618434
Peter thanks that worked great.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply