Questions tagged [identifier]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
56 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
1answer
704 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 ...
7
votes
4answers
5k 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
votes
1answer
140 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 <...
1
vote
1answer
906 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 ...
3
votes
1answer
200 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 ...
4
votes
2answers
1k 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 ...
1
vote
1answer
102 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 ...