Special extended properties

sa_do_not_deploy

Applicable to: constraints

Set this extended property on a constraint to have the deploy ignore it when comparing constraints between deploy source and deploy target.

sa_exclude_from_autocomment

Applicable to: table columns

Auto comment will normally search for procedure calls in all columns whose name ends with "SQL". Set this extended property on a column to have auto comment ignore its content. This is intended to be used for cache tables and log tables.