When tables are involved in referential integrity constraints, the rules for selecting minimal logging are:
All DML statements on a table with referential integrity constraints are always fully logged, overriding any logging settings arrived at for the table based on the database-level or session-specific settings.
You cannot use alter table to change the logging mode of a table to minimal if the table includes referential integrity constraints.
You cannot create any referential integrity constraints between tables that have minimal logging defined for them. For example, creating a foreign referential integrity constraint from a table to its primary table when minimal logging has been explicitly set on the primary table raises an error.
