Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Creating table names that are reserved words/keywords in MS SQL Server [closed]

Tags:

sql

sql-server

Is it ok to name my database tables that are already keywords? For my case, I am trying to name the table that will hold my users. I've named it User but it is showing up as pink in SQL Server Management Studio so I am assuming its an existing System Table or Keyword. Thanks for your advice.

Official list of reserved keywords: Reserved Keywords (Transact-SQL)

like image 608
EverTheLearner Avatar asked Mar 29 '09 23:03

EverTheLearner

People also ask

How do you do a reserved word in SQL?

If you desire to use a reserved word is used as an object name in ANSI standard syntax, it must be enclosed in double-quotes to allow the Relational Engine (whichever that one is) that the word is being used as an object and not as a keyword in the given context.

Can we use reserved words for naming database objects?

If you use a reserved word or symbol to name a field in a desktop database or web app table, Access warns you that the word is reserved and that you might encounter errors when referring to the field. You might also encounter errors if you use a reserved word to name a control, an object, or a variable.

Is name reserved keyword in SQL?

SQL Server does not have to distinguish this as a reserved keyword. Transact-SQL reserved keywords can be used as identifiers or names of databases or database objects, such as tables, columns, views, and so on. Use either quoted identifiers or delimited identifiers.

1 Answers

repeat this three times:

DO NOT DO IT, I WILL NOT USE RESERVED WORDS!

you'll thank me!

like image 70
racer x Avatar answered Sep 27 '22 00:09

racer x
Sign in to Comment

Related questions

Increment Row Number on Group
What does =* mean?
Sql query to select from 1 hour ago?
How do I get the primary key(s) of a table from Postgres via plpgsql?
SQL Server - In clause with a declared variable [duplicate]
Find all stored procedures that reference a specific column in some table
Why use SQL database? [closed]
In SQL / MySQL, what is the difference between "ON" and "WHERE" in a join statement?
How do I add a auto_increment primary key in SQL Server database?
PostgreSQL column 'foo' does not exist
Capturing count from an SQL query
I want to show all tables that have specified column name
How can I roll back my last delete command in MySQL?
SQL How to replace values of select return?
How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
How do I create a comma-separated list using a SQL query?
SQL Server 2008: TOP 10 and distinct together
Laravel Eloquent get results grouped by days
What is ROWS UNBOUNDED PRECEDING used for in Teradata?
Equivalent of explode() to work with strings in MySQL

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!