I want to generically use any SQL database(I'm using jdbc, it works if the driver and the URL are provided).
It seems, that different DBMS use different quoting for table names.
For example, I have the following in MySQL:
SELECT * FROM `tablename`;
while it is
SELECT * FROM [tablename];
in MS SQL Server.
Is there an "uniform" quoting that all databases support? Or is there a jdbc method that gives me tells me the correct quoting?