iFormBuilder Forms

Below is the list of words which cannot be used as a data column name for an element on your form.

PLEASE NOTE: The label of an element can be any word or words you choose, but the actual data column name must not be any of the words below.

You can also download the list by clicking the link at the bottom.

• abort
• absolute
• access
• action
• add
• after
• all
• allocate
• alter
• analyse
• analyze
• and
• any
• are
• array
• as
• asc
• asensitive
• assertion
• asymmetric
• at
• atomic
• attach
• audit
• authorization
• autoincrement
• avg
• before
• begin
• between
• bigint
• binary
• bit
• bit_length
• blob
• boolean
• both
• breadth
• by
• call
• called
• cascade
• cascaded
• case
• cast
• catalog
• change
• char
• char_length
• character
• character_length
• check
• class
• client_id
• clob
• close
• cluster
• coalesce
• collate
• collation
• column
• comment
• commit
• compress
• condition
• conflict
• connect
• connection
• constraint
• constraints
• constructor
• contains
• continue
• convert
• corresponding
• count
• create
• cross
• cube
• current
• current_date
• current_default_transform_group
• current_path
• current_role
• current_time
• current_timestamp
• current_transform_group_for_type
• current_user
• cursor
• cycle
• data
• database
• databases
• date
• day
• day_hour
• day_microsecond
• day_minute
• day_second
• deallocate
• dec
• decimal
• declare
• default
• deferrable
• deferred
• delayed
• delete
• depth
• deref
• desc
• describe
• descriptor
• detach
• deterministic
• diagnostics
• disconnect
• distinct
• distinctrow
• div
• do
• domain
• double
• drop
• dual
• dynamic
• each
• element
• else
• elseif
• enclosed
• end
• equals
• escape
• escaped
• except
• exception
• exclusive
• exec
• execute
• exists
• exit
• explain
• external
• extract
• fail
• false
• fetch
• file
• filter
• first
• float
• float4
• float8
• for
• force
• foreign
• found
• free
• freeze
• from
• full
• fulltext
• function
• general
• get
• glob
• global
• go
• goto
• grant
• group
• grouping
• handler
• having
• high_priority
• hold
• hour
• hour_microsecond
• hour_minute
• hour_second
• id
• identified
• identity
• if
• iformbuilder
• ignore
• ilike
• immediate
• in
• increment
• index
• indexed
• indicator
• infile
• initial
• initially
• inner
• inout
• input
• insensitive
• insert
• instead
• int
• int1
• int2
• int3
• int4
• int8
• integer
• intersect
• interval
• into
• is
• isnull
• isolation
• iterate
• javascript_state
• join
• key
• keys
• kill
• language
• large
• last
• lateral
• leading
• leave
• left
• level
• like
• limit
• lines
• load
• local
• localtime
• localtimestamp
• locator
• location
• lock
• long
• longblob
• longtext
• loop
• low_priority
• lower
• map
• match
• max
• maxextents
• mediumblob
• mediumint
• mediumtext
• member
• merge
• method
• middleint
• min
• minus
• minute
• minute_microsecond
• minute_second
• mlslabel
• mod
• mode
• modifies
• modify
• module
• month
• multiset
• names
• national
• natural
• nchar
• nclob
• new
• next
• no
• no_write_to_binlog
• noaudit
• nocompress
• none
• not
• notnull
• nowait
• null
• nullif
• number
• numeric
• object
• octet_length
• of
• off
• offline
• offset
• old
• on
• online
• only
• open
• optimize
• option
• optionally
• or
• order
• ordinality
• out
• outer
• outfile
• output
• over
• overlaps
• pad
• parameter
• partial
• partition
• path
• pctfree
• placing
• plan
• position
• pragma
• precision
• prepare
• preserve
• primary
• prior
• privileges
• procedure
• public
• purge
• query
• raid0
• raise
• range
• raw
• read
• reads
• real
• recursive
• ref
• references
• referencing
• regexp
• reindex
• relative
• release
• rename
• repeat
• replace
• require
• resignal
• resource
• restrict
• result
• return
• returns
• revoke
• right
• rlike
• role
• rollback
• rollup
• routine
• row
• rowid
• rownum
• rows
• savepoint
• scale
• schema
• schemas
• scope
• scroll
• search
• second
• second_microsecond
• section
• select
• sensitive
• separator
• sequence
• session
• session_user
• set
• sets
• share
• show
• signal
• similar
• size
• smallint
• some
• soname
• space
• spatial
• specific
• specifictype
• sql
• sql_big_result
• sql_calc_found_rows
• sql_small_result
• sqlcode
• sqlerror
• sqlexception
• sqlstate
• sqlwarning
• ssl
• start
• starting
• state
• static
• straight_join
• submultiset
• substring
• successful
• sum
• symmetric
• synonym
• sysdate
• system
• system_user
• table
• tablesample
• temp
• temporary
• terminated
• then
• time
• timestamp
• timezone_hour
• timezone_minute
• tinyblob
• tinyint
• tinytext
• to
• trailing
• transaction
• translate
• translation
• treat
• trigger
• trim
• true
• type
• uid
• under
• undo
• union
• unique
• unknown
• unlock
• unnest
• unsigned
• until
• update
• upgrade
• upper
• usage
• use
• user
• using
• utc_date
• utc_time
• utc_timestamp
• vacuum
• validate
• value
• values
• varbinary
• varchar
• varchar2
• varcharacter
• varying
• verbose
• view
• virtual
• void
• when
• whenever
• where
• while
• window
• with
• within
• without
• work
• write
• x509
• xor
• year
• year_month
• zerofill
• zone
• created_date
• created_by
• created_location
• created_device_id
• modified_date
• modified_by
• modified_location
• modified_device_id
• parent_record_id
• parent_page_id
• parent_element_id