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):
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.