Answered step by step
Verified Expert Solution
Link Copied!

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! image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Harness The Power Of Big Data The IBM Big Data Platform

Authors: Paul Zikopoulos, David Corrigan James Giles Thomas Deutsch Krishnan Parasuraman Dirk DeRoos Paul Zikopoulos

1st Edition

0071808183, 9780071808187

More Books

Students also viewed these Databases questions