Marek: Created page with "CREATE TABLE problems: Invalid column name.

schema:scott

You may not use a reserved word as the name of a field. Many popul..."

2012-07-17T09:12:10Z

Created page with "CREATE TABLE problems: Invalid column name. <div class='ht'> <div class=params>schema:scott</div> <div> <p>You may not use a reserved word as the name of a field. Many popul..."

New page

CREATE TABLE problems: Invalid column name.
<div class='ht'>
<div class=params>schema:scott</div>
<div>
<p>You may not use a reserved word as the name of a field.
Many popular words are used by the system; some words to avoid...<br/><tt>date, day, index, number, order, size, year</tt></p>[http://developer.mimer.se/validator/sql-reserved-words.tml SQL Reserved words]<p>Having a "house-rule" can prevent such problems. Some developers
insist that field names begin with fld for example fldSurname.
Most of us have enough meaningless junk in their lives already; we
don't need this kind of self imposed tyranny.</p>
</div>

<source lang=sql class='tidy'>DROP TABLE t_wrong</source>
<source lang=sql class='setup'></source>

<source lang='sql' class='def e-sqlserver'>CREATE TABLE t_wrong (when DATETIME)
</source>
<source lang='sql' class='def e-access'>CREATE TABLE t_wrong ([date] DATE)
</source>
<source lang='sql' class='def'>CREATE TABLE t_wrong (date DATE)
</source>

<div class="ecomm e-mysql" style="display: none">You can get away with many of these in MySQL; don't do that!</div>
<div class="ecomm e-access" style="display: none">Field names with spaces are permitted. You can use
square brackets to get away with odd field names; don't do that!</div>
<div class="ecomm e-postgres" style="display: none">Some reserved words cause a parse error.</div>
<div class="ecomm e-oracle" style="display: none">You may not use DATE or SIZE or INDEX or NUMBER or ORDER or SIZE
as a field name.
</div>
</div>
{{CREATE and DROP ref}}

CREATE TABLE problems: Invalid column name. - Revision history

Marek: Created page with "CREATE TABLE problems: Invalid column name. schema:scott You may not use a reserved word as the name of a field. Many popul..."

Marek: Created page with "CREATE TABLE problems: Invalid column name.

schema:scott

You may not use a reserved word as the name of a field. Many popul..."