HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Is there a name for the class of characters represented by [] in SQL Server?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
representedtheserversqlnameforcharactersthereclass

Problem

I am interested in the terminology for the characters you can put around table names, column names, etc. when referencing them in a query. A name that in Microsoft SQL Server would be for []s and in MySQL would be for ```s or possibly ""`s.

I am unable to find a generic term for them anywhere and am wondering if one exists.

Solution

"I think" this is what you are referring to:

Delimited Identifiers

https://technet.microsoft.com/en-us/library/ms176027(v=sql.105).aspx

T-SQL Naming Conventions

https://learn.microsoft.com/en-us/sql/t-sql/language-elements/transact-sql-syntax-conventions-transact-sql

Context

StackExchange Database Administrators Q#188231, answer score: 7

Revisions (0)

No revisions yet.