0
Under review

DDL Import Issue: unused tokens were found parsing columns and constraints for table

David Morrison 2 weeks ago updated 1 week ago 3

First time loading DDL script to tool today - mostly it went well but there was one issue that might be a bug...

Error Message

The following unused tokens were found parsing columns and constraints for table: SCHEMA.TABLE.[ []

Scenario


This happened on 2 tables where
1. SQL key words were used as field names*, and

2. there were column names with spaces in them, and
3. all column names were enclosed in square brackets.


I loaded a dozen other tables as part of the same script absolutely fine!

Fix


All I did to fix it was change spaces to underscores in the column names with spaces - I didn't have to do anything for 1. or 3. 

The DDL itself is valid as it came out of the DB. 

Hello,

Into which DB engine did you load the DDL script? MsSQL server?

Best regards,
Adam

Hi,

Yes, MS SQL Server 2017 / 2019.

Thanks