All geek questions in one place

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

I am using Microsoft SQL Server Management Studio to work with a database. I am just a .Net developer with limited experience managing sql server, I am far from a real database administrator. In the next few days, the number of stored procedures will increase dramatically. More types and functions will also be created.

Is there a way to organize these items in folders? I do not want to have dozens of SPs under the same folder. It will be a pain to maintain.

Of course, I know that using a naming convention will help me, but is there anything else I can do?

Thanks.

+4
source share
1 answer

As far as I know, SSMS does not allow you to group schema objects into folders. It is best to use a SQL Server schema to organize your objects. Each scheme will represent a domain of functionality, such as “Client”, “Security”, “Master”, etc. This is a great way to organize your facilities and implement security.

Take a look at this SO thread in the diagram:
What are the benefits of SQL Server schemas?

+4
source

Source: https://habr.com/ru/post/1303231/

More articles:


All Articles