disable Quotes for Fieldnames

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
sud2002
Posts: 1
Joined: Fri 14 Dec 2018 13:55

disable Quotes for Fieldnames

Post by sud2002 » Mon 17 Dec 2018 08:43

i use mariadb 10.3 and dbForge 8.0

and i want do disable the quotes for fieldnames and tablenames.
when i save a view like this

Code: Select all

CREATE
DEFINER = 'root'@'localhost'
VIEW x
AS
SELECT
  testtable.LCHANGE 
FROM testtable;
when i read the view with dbForge -> modify i got this

Code: Select all

CREATE
DEFINER = 'root'@'localhost'
VIEW x
AS
SELECT
  `testtable`.`LCHANGE` AS `LCHANGE`
FROM `testtable`;
i tried every setting in Options > Text Editor > Code Completion > Advanced > Quote Identifier
but i doesnt have an effect.

And is it also possible to disable the alias?

alexa
Devart Team
Posts: 2604
Joined: Fri 24 Jun 2011 14:17

Re: disable Quotes for Fieldnames

Post by alexa » Mon 17 Dec 2018 13:29

This is performed by the MySQL server itself. dbForge just receives the modified data from the MySQL server.

Post Reply