Create TBL Problems - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Create TBL Problems

Author

Topic

Walden
Starting Member

3 Posts

Posted - 2005-07-13 : 11:31:25

Can someone kindly tell me what is wrong with this script: Error messages: Server: Msg 170, Level 15, State 1, Line 7
Line 7: Incorrect syntax near 'varchar'.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near ']'.

********************************************************************

CREATE TABLE dbo.tbl_Currency
(
Currency_ID decimal(18,0) NOT NULL PRIMARY KEY CLUSTERED,
Cur_ShortName varchar (3) NOT NULL,
Cur_Name varchar (60) NOT NULL,
Cur_Description varchar (200) NULL,
Cur_Modification_Date datetime NOT NULL,
Cur_Modification_User varchar (100) NOT NULL,
Cur_Base_Currency char (1) NULL,
Cur_Global_Reporting char (1) NULL,
Cur_Roe decimal (18,4) NULL,
Cur_Sort_Order decimal(18,0) NULL
)

GO

CREATE TABLE dbo.tbl_V_Index_Doc_Status

(

ID_index decimal(18,0) NOT NULL PRIMARY KEY CLUSTERED,
Kfx_Document ID varchar (50) NOT NULL,
Description varchar (50) NULL,
Amount varchar (50) NULL,
DateRefNumber varchar (50) NULL,
Type varchar (50) NULL,
Reason varchar (50) NULL,
Receipient varchar (50) NULL,
CommonName varchar (50) NULL,
CreatedBy varchar (50) NULL,
Currency varchar (50) NULL,
Location varchar (50) NULL,
Opportunity varchar (50) NULL,
Kfxbatch_Name varchar (50) NULL,
Kfxbatch_ID] varchar (50) NULL,
Kfxbatch_Doc_Count varchar (50) NULL,
Kfxbatch_Class_Name] varchar (50) NULL,
kfxbatch_Creation_Date varchar (50) NULL,
Creation_Date datetime NULL,
Status varchar (50) NULL
)

GO

CREATE TABLE dbo.tbl_DefaultCurrencyLookUp

(
Location varchar (100) NULL PRIMARY KEY CLUSTERED,
Currency varchar (50) NULL

)

GO

CREATE TABLE dbo.tbl_Document

(
ID numeric(18,0) IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
KfxdocID varchar (50) NOT NULL,
Kfxpath varchar (512) NULL,
Creation_Date datetime NULL,
Status varchar (50) NULL
)

GO

CREATE TABLE dbo.tbl_Index

(
ID_Index numeric(18,0) IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
KfxdocID varchar (50) NOT NULL,
Text_1 varchar (50) NULL,
Text_2 varchar (50) NULL,
Text_3 varchar (50) NULL,
Text_4 varchar (50) NULL,
Text_5 varchar (50) NULL,
Text_6 varchar (50) NULL,
Receipient varchar (50) NULL,
CommonName varchar (50) NULL,
CreatedBy varchar (50) NULL,
Location varchar (50) NULL,
Opportunity varchar (50) NULL,
Kfxbatch_Name varchar (50) NULL,
Kfxbatch_ID varchar (50) NULL,
Kfxbatch_Doc_Count varchar (50) NULL,
Kfxbatch_Class_Name varchar (50) NULL,
Kfxbatch_Creation_Date varchar (50) NULL,
Creation_Date datetime NULL
)

GO

CREATE TABLE dbo.tbl_Metainfo

(
ID numeric(18,0) IDENTITY(1,1) NOT NULL REFERENCES tbl_Document (ID),
Location varchar (50) NULL,
Opportunity varchar (50) NULL,
Owner varchar (50) NULL,
Recipient varchar (50) NULL,
Type varchar (50) NULL,
Currency varchar (50) NULL,
Fk_Functional_Department numeric(18, 0) NULL,
Fk_Transaction_Type numeric(18, 0) NULL,
Fk_Organisation_Country numeric(18, 0) NULL,
Fk_Line_of_Business numeric(18, 0) NULL,
Fk_Initial_Query_Type numeric(18, 0) NULL
)

GO

CREATE TABLE dbo.tbl_OpportunitylookUp

(
Location varchar (100) NULL REFERENCES tbl_DefaultCurrencyLookUp (Location),
Opportunity varchar (50) NULL

)

GO

CREATE TABLE dbo.tbl_Qcc_Interface_Conf

(
ID int IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
Grp varchar (50) NOT NULL,
Property_Name varchar (50) NOT NULL,
Property_Value varchar (100) NOT NULL
)

GO

CREATE TABLE dbo.tbl_RecipientLookUp

(
SearchString varchar (151) NULL,
Recipient] varchar (50) NULL
)

GO

CREATE TABLE dbo.tbl_Subject

(
ID numeric(18,0) IDENTITY(1,1) NOT NULL REFERENCES tbl_Document (ID),
Subject_Name varchar (50) NULL

)

GO

CREATE TABLE dbo.tbl_Type

(
ID numeric(18,0) IDENTITY(1,1) NOT NULL REFERENCES tbl_Document (ID),
Type_Name varchar (50) NULL
)

GO

CREATE TABLE dbo.tbl_WebInterface_Conf

(
ID int IDENTITY(1,1) NOT NULL REFERENCES tbl_Qcc_Interface_Conf (ID),
Grp varchar (50) NOT NULL,
Property_Name varchar (50) NOT NULL,
Property_Value varchar (100) NOT NULL
)

GO

CarlWalden

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2005-07-13 : 11:59:33

searching for "]" turns up this dodgy column name..."Kfxbatch_ID]"

and there are others!!

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2005-07-13 : 16:21:20

Hi CarlWalden,

Query Analyzer is the best tool for not only executing your queries but also Parsing the queries (syntax checking).

There is an unwanted Bracket (]) in below create table syntax. Pl. remove it and run the script :-)

CREATE TABLE dbo.tbl_RecipientLookUp

(
SearchString varchar (151) NULL,
Recipient] varchar (50) NULL
)

GO

With Regards
Sreenivas Reddy B

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources