Questions tagged [identifier]
The identifier tag has no usage guidance.
11
questions
0
votes
1
answer
25
views
How do you find specific column name in function/sequences
I am trying to see if a specific column exists in any functions/sequences. I have found a script which can search tables, is there anything out there that would allow me to search in functions/...
- 185
-2
votes
1
answer
17
views
Does resetting table ids impact any performance? [closed]
When you have a high number of ids, but they aren't used anymore. Should you reset the id of the table? And does it have any performance difference?
- 1
0
votes
1
answer
440
views
ORA-00904 invalid identifer error when using alias
I'm trying to return a product of two subqueries, and thought I'd make life easier by aliasing each of the subqueries, then divide the two aliases to get the number I'm after, like this:
select ...
- 101
-1
votes
1
answer
6k
views
Identifier that starts with is too long. Max length is 128
I referenced a few other blogs and I can't isolate the issue to this logic.
Code is below. Throws the error message attached.
-- 1. Import Multiple Delimited Text Files into a SQL ...
1
vote
1
answer
3k
views
Relation does not exist while scanning schema
My Postgres database is getting slow while executing some function. But another database of identical design and with more data is much faster than the first one. I have recently migrated data from MS ...
- 125
7
votes
5
answers
13k
views
Why can't object names start with a number?
For example, if I'm creating view with a name '4aii', why does SQL Server care that it starts with a 4? I could call the table Fouraii or IVaii.
Additionally, what does [] do behind the scenes to ...
- 2,514
2
votes
1
answer
217
views
Does the SQL-1992 standard restrict naming identifiers to 18 characters?
In this draft of SQL:1992, I found…
Section 5.2
Leveling Rules
....
The following restrictions apply for Entry SQL in addition to any Intermediate SQL restrictions:
a) No <...
- 9,306
1
vote
1
answer
2k
views
How do I adopt the PostgreSQL naming convention in legacy database?
I realize I'll need to update the queries, but if I have a database that has camelCase or spaces in it, you have to use double quotes on the identifiers (viz. schema, table, column). How do I migrate ...
- 56.7k
3
votes
1
answer
393
views
Test if a string is a valid, unquoted identifier?
I'm just wondering if there is an established method for testing if a string can be used as an unquoted PostgreSQL identifier? (unquoted because almost any string can be a quoted identifier).
I ask ...
- 2,864
4
votes
2
answers
2k
views
Does this regex reliably remove square brackets from T-SQL?
I'm using SQL Server Management Studio 17.4, which supports search-and-replace using a Microsoft version of regular expressions (regex).
I need a regex expression that can reliably remove square ...
- 67.5k
1
vote
1
answer
161
views
What do we call the equivalent of CSS "Specificity" in SQL?
In CSS, the more HTML elements you specify, the more precedence the selector gets. This is known as "specificity." For example,
div p span {...}
Is more specific than, and thus would override:
span ...
- 173