How can we help you today? How can we help you today?

CREATE SCHEMA is not recognized by SQL Prompt 6.5

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
runamuk0
0

Comments

2 comments

Sort by
  • runamuk0
    It also does not work in SQL Prompt 7.
    runamuk0
    0
  • David Priddle
    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
    David Priddle
    0

Add comment

Please sign in to leave a comment.