• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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