Schema name as subfolders
Our project has 40+ schemas. Some of the schemas have several hundred stored procedures, functions, and views. We would like the option for the schema name to be a subfolder under each object type instead of the schema being a prefix on the file name. This would make it easier for developers to find the script files on disk during development as there wouldn't be thousands of files in each object folder.
For example, instead of
"schema-model\Functions\dbo.myFunc1.sql"
the path would be
"schema-model\Functions\dbo\myFunc1.sql".
Duane B
shared this idea
We are working on changes to the UI to show the full schema model in a hierachy of schema/object type/objects and there is a search at the top to quickly find specific objects. Currently, the files on disk are still by object type. We will be running some UX sessions on this in Feb and will update here when we're ready to run the sessions.
