How is SQL Prompt helping your team? Share your experience.
CREATE SCHEMA is not recognized by SQL Prompt 6.5
[email protected]
Posts: 12 Bronze 1
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
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
Comments
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