Does sequence matters while giving constraints in SQL?

Does sequence matter while giving constrains SQL?