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".
1
vote
Duane B
shared this idea