Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Command Index > S > SET

COLCHECK

Scroll Prev Top Next More

Operating Condition

 

Syntax: SET COLCHECK ON/OFF

 

Default: ON

 

Specifies if columns will be checked for consistency when making views.

 

When COLCHECK is ON (the default), view alias/column names will be checked for consistency to other occurrences of those names in the database, when the view is created.

 

Similar checking is in place when creating or modifying tables, and when attaching tables to a database, where R:BASE requires an alias that does not cause name/data type conflicts.