Skip to content

Literals

Andrey Gershun edited this page May 28, 2015 · 3 revisions

Literals

You can use these characters for databases, tables, and other objects names:

  • A-Z
  • a-z
  • _ (underscore)
  • 0-9 (except first character)

For example:

      CREATE TABLE students_a (
        _id serial NOT NULL,
        na_me nvarchar(50) NOT NULL,
        CONSTRAINT students_pkey PRIMARY KEY (_id)
      );

See the example in jsFiddle

If you want to use other characters and spaces, please use square brackets [ ] or back-quote ` to enclose the name:

    SELECT [My column] FROM `Моя табличка-1234()` ORDER BY [今日]

See also: [Case sensivity in AlaSQL](Case Sensitive)

Clone this wiki locally