ERROR: Msg 156, Level 15, State 1, Line 16

I cant figure out what is wrong


See Code Snippet

SQL Server Management Studio returns!
-----------------
Msg 156, Level 15, State 1, Line 16
Incorrect syntax near the keyword 'Transaction'.
Msg 156, Level 15, State 1, Line 41
Incorrect syntax near the keyword 'Transaction'.
Msg 156, Level 15, State 1, Line 71
Incorrect syntax near the keyword 'Transaction'.
Msg 156, Level 15, State 1, Line 74
Incorrect syntax near the keyword 'Transaction'.
Msg 156, Level 15, State 1, Line 75
Incorrect syntax near the keyword 'Transaction'.



create table Transaction.Currency (CurrencyID uniqueidentifier default (NewSequentialID()) not null, CurrencyCode nchar(3) not null unique, Name varchar(50) not null unique, constraint PK_Currency primary key (CurrencyID));
alter table Transaction.CountryRegionCurrency add constraint FK_CountryRegionCurrency_CurrencyID_Currency foreign key (CurrencyID) references Transaction.Currency;
alter table Transaction.CountryRegionCurrency add constraint FK_CountryRegionCurrency_CountryRegionID_CountryRegion foreign key (CountryRegionID) references Person.CountryRegion;
alter table Person.ContactInformation add constraint FK_ContactInformation_PrimaryCurrencyID_Currency foreign key (PrimaryCurrencyID) references Transaction.Currency;
alter table Person.BusinessInformation add constraint FK_BusinessInformation_PrimaryCurrencyID_Currency foreign key (PrimaryCurrencyID) references Transaction.Currency;

Open in new window

KhouAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

KhouAuthor Commented:
SQL Server does not want to the currency table, WHY?
Because it didn't like it that all fields has to be unique???

The other 4 error is because the Currency table does not exist, and can not be reference to a non existing table.
0
Steve HoggITCommented:
Put keywords used as objects in brackets [transaction].[currency]
0
KhouAuthor Commented:
hi which word is the keyword?
0
Steve HoggITCommented:
The word TRANSACTION is a keyword in SQL Server.
SQL Server Reserved Keywords
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
KhouAuthor Commented:
yep I figured

thanks :)

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.