I am having a problem creating a VIEW on SQL. I have all the required tables built, however when I specify to use a DATABASE
CREATE VIEW abc_only AS
SELECT letter, Font, inserted_date
WHERE role = 'noun'
I get the following error:
'CREATE VIEW' must be the first statement in a query batch.
What is causing this error?