7 Nokia Corporation - initial contribution. |
7 Nokia Corporation - initial contribution. |
8 Contributors: |
8 Contributors: |
9 --> |
9 --> |
10 <!DOCTYPE concept |
10 <!DOCTYPE concept |
11 PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd"> |
11 PUBLIC "-//OASIS//DTD DITA Concept//EN" "concept.dtd"> |
12 <concept xml:lang="en" id="GUID-8579426F-C443-558B-9380-FED79D4BA8F4"><title>Rules for DBMS names</title><prolog><metadata><keywords/></metadata></prolog><conbody><p><keyword>Tables</keyword>, <keyword>indexes</keyword> and <keyword>columns</keyword> are named objects within a <keyword>database</keyword>. A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the <codeph>_</codeph> (underscore) character may be used. DBMS names are also limited to 64 characters in length.</p> <p>Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named <codeph>column_one</codeph> and <codeph>Column_ONE</codeph> are considered to have the same name.</p> <p>Names in a database have no further restrictions.</p> </conbody></concept> |
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> |