Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have the following schema that I am trying to create but I keep getting the following error messages that I cannot fix! On CREATE
I have the following schema that I am trying to create but I keep getting the following error messages that I cannot fix!
On "CREATE SCHEMA" these are my errors:
Incorrect syntax: 'CREATE SCHEMA' must be the only statement in the batch.
The CREATE SCHEMA statement should be followed by a name or authorization keyword.
On "AS" this is my error:
Incorrect syntax near 'AS'.
On "[Homework]" this is my error:
Incorrect syntax near 'AS'.
PLZ HELP!!!!
CREATE SCHEMA AS [Homework]; CREATE TABLE [Homework].Locations LocationKey int IDENTITY (1,1) PRIMARY KEY NOT NULL LocationName varchar (50) NOT NULL Addressi varchar (50) NOT NULL Address2 varchar(50) NULL, City varchar(50) NOT NULL, StateCode char(2) NOT NULL ZipCode char(5) NOT NULL Zip4 char(4) NULL )i
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started