Questions tagged [reserved-word]
The reserved-word tag has no summary.
9 questions
10 votes
3 answers
2k views
Is the keyword "ALIAS" actually used?
According to PostgreSQL 7.1 through 9.1 (now unsupported), ALIAS is listed as a reserved word, at least for SQL-99. Later versions do not show it - suggesting that it has been dropped as a reserved ...
user4930
0 votes
1 answer
287 views
System-level way to enforce that reserved words may not be used for Oracle column names?
Is there a way in Oracle 12c to enforce that reserved words / keywords may not be used as column names? I am aware that it is not good practice to use keywords in this way. However from what we have ...
- 101
3 votes
4 answers
9k views
MySQL similar name for status or type column
As status and type is reserved key in MySQL, I need a column name similar to status to identify the status of a row. I know there is way to ignore this problem but in different language and different ...
- 101
-1 votes
1 answer
510 views
Why would SQL queries that use reserved words suddenly start causing problems?
In the past couple of days we have experienced issues with 3 different applications that have been running fine for several years. Errors #1 and #2 were caused by reserved words in SQL queries. I am ...
- 1
3 votes
1 answer
3k views
What problems would using the reserved keywords DATE and TIME as column names cause in Oracle?
DATE is an SQL Reserved Word and TIME is a PL/SQL Reserved Word in Oracle (listed in SQL> HELP RESERVED WORDS). What problems would using them as column names cause in Oracle? The database server ...
- 2,103
2 votes
1 answer
1k views
trigger can't access column loop
SSCCE: The following script: $ cat test.sql CREATE TABLE public.foo ( loop INTEGER ); CREATE OR REPLACE FUNCTION public.foo_fun(loop INTEGER) RETURNS BOOLEAN AS $$ SELECT TRUE; $$ LANGUAGE SQL; ...
- 3,419
1 vote
1 answer
369 views
why is the name `loop` treated differently in PostgreSQL
I issue the following DDL: CREATE TABLE foo ( loopa INTEGER, loop INTEGER ); Then, examining the DDL in the server (using a client-side tool like DbVisualizer - sorry don't know the query to produce ...
- 3,419
4 votes
1 answer
4k views
What is the purpose of the keyword "ID" in PostgreSQL?
I'm new to PostgreSQL and I ran into problems using the following query: SELECT * FROM table1 WHERE ID = 1 ERROR: column "id" does not exist LINE 2: WHERE ID = 1 where ID is a column I added via ...
- 647
15 votes
1 answer
2k views
Why is "Lookup" colored as a function reserved word in SQL Server?
In SSMS 2208, the identifier "Lookup" is colored hot pink as if it were a function (same color as, say, "Power" or "Convert"). Why? I cannot find it in the official list of reserved words. Searches ...
- 4,355