unable to create table for sql database using dbsebdquery

ERROR: "Error: nanodbc/nanodbc.cpp:1617: 00000: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is
'Create table Exposure_bymodifiers"

Other query is working fine, only facing issue with creating table.

Temp_table = dbSendQuery(con, "Create table Exposure_bymodifiers
( portinfoid int,
country varchar(100),
peril int,
bldgscheme varchar(100),
bldgclass varchar(100),
occscheme varchar(100),
occtype varchar(100),
yearbuilt date,
numstories varchar(100),
TSI_USD bigint ) ")

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.