Creating a table

[JackSkellington]

Is there any way to create a new table with a space in the middle i.e TABLE 1. I have tried using [] but get an error.

CREATE TABLE `TABLE 1` (
`Supply Sub System` VarChar (8) ,
`SSS Description` VarChar (40) ,
`DG1` VarChar (4) ,
`Site Ref` VarChar (8) ,
`Site Description` VarChar (40) ,
`Input or Output` VarChar (1) ,
`Include` VarChar (1) )

 

[unclerico]

that should work just fine

CREATE TABLE [table 1](
 [Supply Sub System] VarChar (8) , 
 [SSS Description] VarChar (40) , 
 DG1 VarChar (4) , 
 [Site Ref] VarChar (8) , 
 [Site Description] VarChar (40) , 
 [Input or Output] VarChar (1) , 
 [Include] VarChar (1)
)

Although, unless there is some sort of predefined business rule where you need spaces, you should refrain from using them; instead use underscores or no spaces at all

 

[JackSkellington]

This would work as a SQL statment but doesn't work when creating thetable through DTS

 

[unclerico]

works just fine for me, no issues at all