Options

CREATE SCHEMA is not recognized by SQL Prompt 6.5

runamuk0@msn.comrunamuk0@msn.com Posts: 12 Bronze 1
edited November 2, 2015 5:14AM in SQL Prompt
Hi,
I am creating new schemas in my database and I noticed that when I type CREATE S... the word SCHEMA does not appear in the list. In addition when I reformat code the reformat errors on the CREATE SCHEMA line.

Thanks,
Tony Green
· Share on Twitter

Comments

  • Options
    runamuk0@msn.comrunamuk0@msn.com Posts: 12 Bronze 1
    It also does not work in SQL Prompt 7.
    · Share on Twitter
  • Options
    David PriddleDavid Priddle Posts: 218
    Hi Tony,

    Is it the only statement in the batch (GO block)? If not, if you add a GO on a line before and try again, does SCHEMA come up in the suggestions?

    SQL Server is a little picky when it comes to certain statements, requiring them (like CREATE SCHEMA and CREATE PROCEDURE) to be the only statement in the batch.

    Best regards,

    David
    · Share on Twitter
Sign In or Register to comment.