Table Queries

Query	The Returned Rows Indicate	Resolution
TABLE-1	SQL table names are defined in the Data Designer that are not blank and not the same as the record name.	Use the Application Designer to enter the record name as the Non-Standard SQL Table Name.
TABLE-2	SQL tables are defined in the Data Designer and not found in the database.	If you want to delete the record definition, use Application Designer (select File, Delete). Otherwise, to create the SQL table, use Application Designer. This command also creates the appropriate indexes for keys, duplicate order keys, alternate keys, and list items.
TABLE-3	SQL tables are defined in the database and not found in the Data Designer. SYSINDEXES and SYSTABLES can be ignored in these results.	Drop the table if it is not valid. Otherwise, define a new record in the Application Designer.
TABLE-4	Tablespace is not defined for the SQL table in Application Designer.	If you're using or migrating to a relational database management system that uses table spaces, you should use the Application Designer to assign table spaces to these tables.
TABLE-5	Table contains more than 500 fields.	Use the Application Designer to adjust the number of fields on the table, as needed.