Re: can you name a column in sybase with underscore?

On May 18, 10:06 am, sybaselady <dcsoi...@xxxxxxxxx> wrote:
Quick question about naming conventions in sybase.

Can you name a column starting with _

say for example Could you name a column

_CREATED

Thanks

What do you mean by "in sybase"? Sybase is a company, it has many
different products that your question might apply to.

If you are asking about Sybase Adaptive Server Enterprise, you can.
Per the manual:

Most user-defined Adaptive Server identifiers can be a maximum of 255
bytes in length, whether single-byte or multibyte characters are used.
Others can be a mximum of 30 bytes. Refer to the Transact-SQL User's
Guide for a list of both 255-byte and 30-byte identifiers.

The first character of an identifier must be either an alphabetic
character, as defined in the current character set, or the underscore
(_ ) character.

NoteTemporary table names, which begin with the pound sign (#), and
variable names, which begin with the at sign (@), are exceptions to
this rule.

Subsequent characters can include letters, numbers, the symbols #, @,
_, and currency symbols such as $ (dollars), ¥ (yen), and £ (pound
sterling). Identifiers cannot include special characters such as !, %,
^, &, *, and . or embedded spaces.

You cannot use a reserved word, such as a Transact-SQL command, as an
identifier. For a complete list of reserved words, see Chapter 5,
"Reserved Words."

You cannot use the dash symbol ( - ) as an identifier.


.

Relevant Pages

  • The annotated annotated annotated C standard part 2
    ... Algol meaning, a profoundly important meaning which acknowledges the ... notice that a character is defined as 8 bits (1 ... ## No other keywords are allowed in a conforming program. ... particularly important for identifiers with block scope. ...
    (comp.programming)
  • Re: Factory Pattern
    ... It has the ISO standard and surely will be revised. ... to use Unicode identifiers, ... "3 Each universal character name in an identifier shall ...
    (comp.lang.ada)
  • Re: Ada Answers
    ... >>for Gnat accept these identifiers? ... to the extent that accentuated identifiers are Western ... 8bit character on the command line, ... cmd shows replacement characters. ...
    (comp.lang.ada)
  • Re: Variable Declaration syntax?
    ... Beside making the lexing easier as our moderator mentioned, ... identifiers in certain instances. ... I defined a language where an arbitrary character ...
    (comp.compilers)
  • Problem with semi-colon
    ... To connect to Sybase I use ODBC via Visual Basic. ... But when I have a special character I get an error. ... Is there a escape character for this??? ...
    (comp.databases.sybase)