View source for Error Messages: SQL

=Recital/SQL Error Messages=

{| class="wikitable"
!ERROR()||Error Message
|-
|5000||Unrecognized phrase/keyword near column <expN>
|-
|5001||Table name was expected
|-
|5002||Column name was expected
|-
|5003||Column name already exists
|-
|5004||Data type was expected
|-
|5005||Unrecognized data type for column <column name>
|-
|5006||Invalid specification for column <column name>
|-
|5007||Keyword PRECISION was expected
|-
|5008||Cannot create table <nowiki><table name></nowiki>
|-
|5009||Invalid table specification
|-
|5010||Cannot open table <nowiki><table name></nowiki>
|-
|5011||Keyword TABLE expected
|-
|5012||Keyword ADD expected
|-
|5013||<command expression> - operation aborted
|-
|5014||Keyword INTO expected
|-
|5015||Keyword VALUES expected
|-
|5016||Keyword SQL expected
|-
|5017||Keyword FROM expected
|-
|5018||’=’ expected
|-
|5019||Keyword SET expected
|-
|5020||Keyword INDEX expected
|-
|5021||Index name expected
|-
|5022||Keyword ON expected
|-
|5023||Keyword BY expected
|-
|5024||Keyword UPDATE expected
|-
|5025||FROM clause missing
|-
|5026||Bad ORDER BY clause
|-
|5027||Bad GROUP BY clause
|-
|5028||Cursor name was expected
|-
|5029||Cursor already declared
|-
|5030||Keyword CURSOR was expected
|-
|5031||Keyword FOR was expected
|-
|5032||Too many cursors declared
|-
|5033||Cursor is not open
|-
|5034||Cursor not declared
|-
|5035||Cursor is already open
|-
|5036||INTO list does not match SELECT list
|-
|5037||Specified cursor is not updateable
|-
|5038||Keyword TO expected
|-
|5039||No CURRENT record
|-
|5040||Exclusive tables cannot be locked
|-
|5041||Keyword SHARE or EXCLUSIVE expected
|-
|5042||Keyword MODE expected
|-
|5043||Keyword IN expected
|-
|5044||Keyword SELECT expected
|-
|5045||Keyword JOIN expected
|-
|5046||Invalid join expression
|-
|5047||Operation not supported on a VIEW
|-
|5048||View not declared
|-
|5049||VIEW already declared
|-
|5050||View name was expected
|-
|5051||Column ’<column name>’ not found
|-
|5052||Table privilege expected
|-
|5053||User name was expected
|-
|5054||User name <user name> was not found
|-
|}

[[Category:Documentation]]
[[Category:Reference]]
[[Category:SQL]]