there is no auto generated constraints in sql that you will need to disable them.
every constraint is applied explicitely , so as per your requirement you may or may not use constraints.
for example if you don't want a foreign key constraint then don't apply it but then you will loose database integrity soon.