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

Naming indexes with SQL

How do I create a index that has spaces ex. "index 2" with a SQL statement, if it was a column you could use E."column 1", but this dosn't seems to work on indexes.
0
koger
Asked:
koger
1 Solution
 
ZifNabCommented:
Hi koger,
Why do you need a space? This will always give you troubles (my opinion). I usually use instead of a space an underscore '_'
Regards, fiz.
0
 
zandyCommented:
The use of space in indexes is not by any means
possible according Ansi SQL specifications.


0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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