Pay attention to the table name when designing the SQL Server database.

I did not pay too much attention to the table name when designing the database. I designed a user, order, and modify table. I think there is no problem, you can find a problem only when using exported SQL to generate a database.

 

These table names are highlighted, and they are defined in the system. The SQL statement cannot be select * from user.

 

It can only be executed by select * from "user. It causes great inconvenience to the Development. Besides, the user table exists, but in the Manager

 

No.

 

The solution is to change the table name. Otherwise, it would be unfriendly to write "user" when writing SQL statements.

It is better to rename the table name in the Manager instead of executing exex sp_rename because the table name must be added with "" invalid.

 

 

I only hope you will pay more attention in the future and avoid unnecessary troubles.