Error Messages: SQL

Lianja/SQL Error Messages

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 <table name>
5009	Invalid table specification
5010	Cannot open table <table name>
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