Chapter 6 Working with PDMs

Foreign key column data type and constraint parameters divergence

Primary/alternate and foreign key columns involved in a join should have consistent data types and constraint parameters.

Manual correction Automatic correction
Modify foreign key data types and constraint parameters to make them consistent Parent column overwrites existing data type and constraint parameters in the foreign key column

 

Copyright (C) 2005. Sybase Inc. All rights reserved.