Devart Forums

Posted: **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?

Posted: **Mon 17 Dec 2018 13:29**

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

Devart Forums

disable Quotes for Fieldnames

disable Quotes for Fieldnames

Re: disable Quotes for Fieldnames