Table Builder Criteria

Certain requirements must be met in order for the Column names in Custom Tables to be accepted.

  1. Column names in custom tables must start with a letter; they cannot start with a number, however they may contain numbers.

  2. Column names cannot be more than 30 characters long

  3. The following is a list of the "reserved words" that cannot be used as a column name with the Table Builder:

        • ACCESS

        • ADD

        • ALL

        • ALTER

        • AND

        • ANY

        • AS

        • ASC

        • AUDIT

        • BETWEEN

        • BY

        • CHAR

        • CHECK

        • CLUSTER

        • COLUMN

        • COMMENT

        • COMPRESS

        • CONNECT

        • CREATE

        • CURRENT

        • DATE

        • DECIMAL

        • DEFAULT

        • DELETE

        • DESC

        • DISTINCT

        • DROP

        • ELSE

        • EXCLUSIVE

        • EXISTS

        • FILE

        • FLOAT

        • FOR

        • FROM

        • GRANT

        • GROUP

        • HAVING

        • IDENTIFIED

        • IMMEDIATE

        • IN

        • INCREMENT

        • INDEX

        • INITIAL

        • INSERT

        • INTEGER

        • INTERSECT

        • INTO

        • IS

        • LEVEL

        • LIKE

        • LOCK

        • LONG

        • MAXEXTENTS

        • MINUS

        • MLSLABEL

        • MODE

        • MODIFY

        • NOAUDIT

        • NOCOMPRESS

        • NOT

        • NOWAIT

        • NULL

        • NUMBER

        • OF

        • OFFLINE

        • ON

        • ONLINE

        • OPTION

        • OR

        • ORDER

        • PCTFREE

        • PRIOR

        • PUBLIC

        • RAW

        • RENAME

        • RESOURCE

        • REVOKE

        • ROW

        • ROWID

        • ROWNUM

        • ROWS

        • SELECT

        • SESSION

        • SET

        • SHARE

        • SIZE

        • SMALLINT

        • START

        • SUCCESSFUL

        • SYNONYM

        • SYSDATE

        • TABLE

        • THEN

        • TO

        • TRIGGER

        • UID

        • UNION

        • UNIQUE

        • UPDATE

        • USER

        • VALIDATE

        • VALUES

        • VARCHAR

        • VARCHAR2

        • VIEW

        • WHENEVER

        • WHERE

        • WITH

        • [

        • ]

        • ^

        • |

        • !

        • &

        • (

        • )

        • *

        • +

        • ,

        • -

        • .

        • /

        • :

        • <

        • =

        • >

        • @

 

Related topics