Organize stored procedures, views, functions etc with sql management studio.

Question

Hi

I'm using Microsoft SQL Server Management Studio to work with a database. I'm only a .Net developer with limited experience in managing sql server, I'm far from a real DBA. In next few days, the number of stored procedures are going to increase very much. Also more views and functions will be created.

Are there any way to organize this elements in folders? I don't want to have dozens of SP under the same folder. It will be a pain to maintain.

Of course, I know that using a name convention will help me, but are there anything more that I can do?

Thanks.

Answer 1

As far as I know, SSMS doesn't allow you to group schema objects in folders. Your best bet would be to use SQL Server Schema's to organize your objects. Each schema would represent an area of functionality such as 'Customer', 'Security', 'Master' etc. This is a great way to organize your objects, and implement security.

Take a look at this SO thread on Schema's:
http://stackoverflow.com/questions/529142/what-good-are-sql-server-schemas