SQL Schemas

• peer_mohamed2k

  Mr or Mrs. 500

  Points: 510

  More actions

  September 25, 2008 at 2:51 am

  #191412

  Hi,

  Can SQL Schemas can have dot in its name?

  I have schema created with dot in its name. But while using for queries it is not working.

  Can anyone help on this?

  Thanks,

  Peer Md.

• Michael Earl-395764

  SSC Guru

  Points: 53873

  More actions

  September 25, 2008 at 5:51 am

  #876904

  You would have to enclose it in square brackets:

  [My.Schema].[MyTable]

  I would say that putting a dot in your schema name is a really bad idea.