Terminating null reference error when generating HTML for Constraints MSSQL

[kylefossum]

Terminating null reference error when generating HTML for Constraints MSSQL

[npetzall]

Hi,

It's the following query
select OBJECT_NAME(parent_object_id) as table_name, name AS constraint_name, definition as text from sys.check_constraints

That returns null for the text alias of definition in sys.check_constraints

Are you able to run the query as well as just list columns in sys.check_constraints. I wonder if they might have changed the column name or something like that. Since it would be strange from a db perspective to have a check constraints thats missing the check definition.

There might be a scenario that I'll look into if they have any secondary columns that defines a function or something like that.

If the table is empty we are creating an empty entry when nothing should be added.