CODEWITHSUNDEEP
azure-sql-database
Gary
Gary

Reputation: 2261

azure db field name (column name) limitations

Anyone know where in the MS docs this kind of thing is defined (I'm specifically looking for what characters are allowed in the field names... IE unicode). I haven't found hard docs yet, but the wording I've seen seems to indicate that it's collation dependent in the same way the tuples are.

If that's the case I'd love to see where in the docs that info is located. IE if it's in the azure docs / sql server docs etc.

Thanks!

Upvotes: 0

Views: 226

Answers (1)

luck02
luck02

Reputation: 26

I was unable to find any hard documentation on this subject, but the answer is yes. It depends on system collation as documented here (the documentation does NOT actually answer the question though)

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-table-transact-sql?view=sql-server-2017

https://learn.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance-transact-sql-information

https://azure.microsoft.com/en-ca/blog/working-with-collations-in-sql-azure/

https://learn.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support?view=sql-server-2017

It looks like at this stage, this is really poorly documented in Azure.

Upvotes: 1

Related Questions