#1141 Contents not showing for some table

[-c^s- Tan]

In MSSQL, if the table has a column named "Order" (any datatype), the Content tab will not work. Eg:

CREATE TABLE "dbo"."TestTable007" ( [Order] nvarchar(100) )


Confirmed with these:
com.microsoft.sqlserver.jdbc.SQLServerDriver v4.0.2206.100
MSSQL 2012 Express v11.00.3000
MSSQL 2008R2 Express v10.50.4000

No problem on MySQL. (probably issue with MSSQL driver but it works in Squirrel v3.5.0)

[-c^s- Tan]

Same problem using jDTS driver v1.3.1

[sfst]

Can you please specify what does "the Content tab will not work" mean? No values shown, or some error message?

In Oracle I must quote the column name in this case, e.g. create table order_test("Order" number);
and then always use the exact upper/lower case for quoted columns, e.g. SELECT "Order" FROM order_test;

If I use SELECT "order" FROM order_test; I get an error that the identifier "order" is not known.

If I use SELECT Order FROM order_test; the error is about a missing expression.