... created implicitly are pain in the ass.
Note to myself: ALWAYS explicitly name your default constraints, otherwise altering/dropping columns across different servers becomes major headache.
P.S. Not mentioning that system tables that can be used to find implicit constraints change between SQL Server releases...
P.P.S This link helps.
No comments:
Post a Comment