SQL Server 2005 Schema Usage

Any template questions or comments or suggestions

SQL Server 2005 Schema Usage

Postby ati_ozgur on Thu Mar 08, 2007 9:57 pm

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.
ati_ozgur
Lurker
 
Posts: 6
Joined: Mon Jul 11, 2005 6:37 am

Postby mike.griffin on Fri Mar 09, 2007 7:03 pm

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.
User avatar
mike.griffin
Site Admin
 
Posts: 3290
Joined: Sat Apr 03, 2004 6:10 am
Location: Indianapolis, IN

Postby ormico on Tue Oct 30, 2007 2:51 pm

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

}
ormico
Corporal
 
Posts: 21
Joined: Mon Mar 26, 2007 2:16 pm


Return to General Template Questions/Comments

Who is online

Users browsing this forum: No registered users and 1 guest