Solved

Naming indexes with SQL

Posted on 1998-06-12
2
167 Views
Last Modified: 2010-05-18
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
Comment
Question by:koger
2 Comments
 
LVL 8

Expert Comment

by:ZifNab
ID: 1352509
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
 

Accepted Solution

by:
zandy earned 50 total points
ID: 1352510
The use of space in indexes is not by any means
possible according Ansi SQL specifications.


0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question