Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 559
Jonathan Avatar asked Mar 05 '10 12:03

Jonathan


1 Answers

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:
What good are SQL Server schemas?

like image 137
Randy Minder Avatar answered Oct 20 '22 01:10

Randy Minder