Unable to select all the rows when creating a Database Schema.

I would say it’s the dashes.  In sql you need to enclose a column name in brackets when there are special characters so the jdbc and/or the gui are probably having issues.

I’ve never had to do this, but you should be able to create a schema from sql and manually add the fields to the select statement with brackets.

I would tell you dba not to use dashes 😉

• This reply was modified 3 months, 2 weeks ago by John Mercogliano.

Excellent glad that worked.

Rin,

Nothing looks out of place here.  I would recommend to resync the database schema to make sure nothing has changed.  Then try and create a schema using sql with some of the columns that won’t select using brackets. I’ve never had an issue like this so just reaching at this point.