Nested Schemas

• Luis Cazares

  SSC Guru

  Points: 183706

  More actions

  November 19, 2015 at 9:12 am

  #1841046

  sestell1 (11/19/2015)

  ---

  I like to add square brackets around my nested schemas. :-D:crazy::hehe:

  CREATE SCHEMA [[a]].].[c]]]

  I'm not sure if that's confusing enough.

  Luis C.
  General Disclaimer:
  Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

  How to post data/code on a forum to get the best help: Option 1 / Option 2

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738140

  More actions

  November 19, 2015 at 3:19 pm

  #1841207

  sestell1 (11/19/2015)

  ---

  I like to add square brackets around my nested schemas. :-D:crazy::hehe:

  CREATE SCHEMA [[a]].].[c]]]

  Noooooooooooooooooooooooooooooooooooooooooooo

• patricklambin

  SSCrazy Eights

  Points: 9994

  More actions

  November 19, 2015 at 3:29 pm

  #1841214

  Steve Jones - SSC Editor (11/19/2015)

  ---

  sestell1 (11/19/2015)

  ---

  I like to add square brackets around my nested schemas. :-D:crazy::hehe:

  CREATE SCHEMA [[a]].].[c]]]

  Noooooooooooooooooooooooooooooooooooooooooooo

  good joke

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  November 23, 2015 at 2:02 pm

  #1841855

  Thanks for the question. It generated a few interesting comments.

• patricklambin

  SSCrazy Eights

  Points: 9994

  More actions

  November 23, 2015 at 4:17 pm

  #1841891

  My last reply about this exciting QOD.

  I have appreciated all the posts as each one learnt me something , even the "joke".

  When I installed my SQL Server 2008 Developer ( a long time ago 7 years ) , I have created an application ( the same ones in VC# and VB ) to recreate the full creation script of a database . During the test of the VC# version , I discovered the problem of the characters needing the use of the brackets to put around the same of some objects having "invalid" characters.

  After around 6 months , when the code was ended , I remembered that I was horrified by the lack of easiness to read this script as every name was surrounded by brackets. It is why I never dared to post the code of this application. I kept it for me , considering it only like a game with SMO ( SQL Server Management Objects ). Moreover , I was not sure that my work could be useful in a real company but I have learnt about 90% of my current knowledge about SMO and I began able to post usefully on the SMO forum.