Knowledge Base Article 1

DB Manager Field/Table Addition Error

Type: Database Error

Version: All

Server Platform: All

Problem:

Error occurs when creating new tables or fields in DB Manager. Tables/fields are created despite errors.

Solution:

Key/Reserved words can’t be used for fields, choose another word. Check Microsoft for new or edited Reserved Words on newer versions of SQL Server.

Error examples:

"VALUE is not a valid table name, it is already used as a keyword"
"Invalid field name!"

Back to the List of Errors