When I was exploring the master
database in SSMS
I noticed that under the Tables
folder there is another folder called Systems Tables
that houses a bunch of tables. Is it possible for us to create a structure akin to Systems Tables
within our database?
I am looking to organize tables and stored procedures into project specific folders. Under the new setup - when I am referring to my table object I would have to use the following syntax (I am guessing here):
[dbName].[projectName].[dbo].[tableName]
Also, apart from clearing up the clutter, do anybody foresee any performance improvement/degradation because of this re-organization? I use Microsoft SQL Server 2008 R2
.