• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3960
  • Last Modified:

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

0
Khou
Asked:
Khou
  • 3
  • 2
1 Solution
 
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
 
HoggZillaCommented:
Put keywords used as objects in brackets [transaction].[currency]
0
 
KhouAuthor Commented:
hi which word is the keyword?
0
 
HoggZillaCommented:
The word TRANSACTION is a keyword in SQL Server.
SQL Server Reserved Keywords
0
 
KhouAuthor Commented:
yep I figured

thanks :)

0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now