SQL Server 2005 Schema Usage

[ati_ozgur]

I use schemas heavily in my Database Design. When I get table list in templates they show all tables in my database. Is there any way I can filter this list according to my schemas. For example lets say that I use four schemas in my database design.

Common
Module1
Lookup_Common
Lookup_Module1

I would like to see for example only tables which belongs to Module1 in ListBox.

[mike.griffin]

Our templates don't filter on that, however, those are properties on ITable and IDatabase I believe so you could perhaps, also, if you logged on using a SQL user id that only had access to that schema that might do it as well.

[ormico]

this is an old post, but I thought I would post how I do this

Code: Select all

foreach(IProcedure objProc in database.Procedures)
{
   if(objProc.Schema != mySchema)
   {
      continue;
   }

// do stuff

}