1 <?xml version="1.0" encoding="utf-8"?>

     2 <!-- Copyright (c) 2007-2010 Nokia Corporation and/or its subsidiary(-ies) All rights reserved. -->

     3 <!-- This component and the accompanying materials are made available under the terms of the License 

     4 "Eclipse Public License v1.0" which accompanies this distribution, 

     5 and is available at the URL "http://www.eclipse.org/legal/epl-v10.html". -->

     6 <!-- Initial Contributors:

     7     Nokia Corporation - initial contribution.

     8 Contributors: 

     9 -->

    10 <!DOCTYPE concept

    11   PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd">

    12 <concept id="GUID-8579426F-C443-558B-9380-FED79D4BA8F4" xml:lang="en"><title>Rules

    13 for DBMS names</title><shortdesc>Tables, indexes, columns etc. have naming restrictions such as

    14 they must begin with an alphabetic character. This document lists those rules.</shortdesc><prolog><metadata><keywords/></metadata></prolog><conbody>

    15 <p><keyword>Tables</keyword>, <keyword>indexes</keyword> and <keyword>columns</keyword> are

    16 named objects within a <keyword>database</keyword>. A DBMS name must begin

    17 with an alphabetic character, after which any alphabetic, numeric or the <codeph>_</codeph> (underscore)

    18 character may be used. DBMS names are also limited to 64 characters in length.</p>

    19 <p>Table names must be unique within a database, and columns and indexes must

    20 have unique names within the table to which they belong. For the purposes

    21 of uniqueness and identification, the names are folded before comparison,

    22 so two columns named <codeph>column_one</codeph> and <codeph>Column_ONE</codeph> are

    23 considered to have the same name.</p>

    24 <p>Names in a database have no further restrictions.</p>

    25 </conbody></concept>