Legal/illegal characters in table name

  • Comments posted to this topic are about the item Legal/illegal characters in table name

  • This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

  • MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1

    Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!

    :w00t:

  • MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    Yep:-

    Msg 2760, Level 16, State 1, Line 1

    The specified schema name "tmp" either does not exist or you do not have permission to use it.

  • Carlo Romagnano (4/8/2015)


    MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1

    Ahi, ahi, ahi, ahi, ahi, ahi!!!!!!!!!!

    :w00t:

    +1

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • +1

    I was going to write exactly the same 🙂

  • Nice question, but a bit of an oversight on the tmp schema.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Same Here.. +1

  • Thanks for the post, good one.

    I was of sure of usage of square brackets will lead to the successful table creation, and that "tmp." schema name- as not all databases will have it, so I thought "well yea... error".

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Good question. Possible but not practical.

    Igor Micev,My blog: www.igormicev.com

  • I got this when I ran it:

    Msg 2760, Level 16, State 1, Line 1

    The specified schema name "tmp" either does not exist or you do not have permission to use it.

    .....and no table created. So I have to disagree with the "correct" answer.....

  • Like some others, I guessed wrongly that the "trick" to this question was about the schema 🙁

  • This was removed by the editor as SPAM

  • MyDoggieJessie (4/7/2015)


    This assumes that you have a schema in the database named "tmp" otherwise it fails because the schema does not exist.

    +1, this should have been mentioned in the question.

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • Stewart "Arturius" Campbell (4/8/2015)


    Good question, despite the tmp schema "issue"

    Highlights the difference between what is possible and what is practical.

    True, this is possible but not practical @ all, who will ever think about naming a table (char(13))?! 😀

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

Viewing 15 posts - 1 through 15 (of 52 total)

You must be logged in to reply to this topic. Login to reply