Changing Foreign key names to standard naming convention across the DB
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2011-07-06 (first published: 2010-02-09)
1,153 reads
Rename the Foreign keys to standard notation - FK_childTable_ParentTable
2011-07-06 (first published: 2010-02-09)
1,153 reads
2010-01-25
3,933 reads
2010-01-07 (first published: 2009-12-18)
1,696 reads
2009-01-23 (first published: 2009-01-14)
1,955 reads
Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.
2009-01-19 (first published: 2009-01-05)
1,290 reads
2008-10-24
740 reads
2008-09-11
1,512 reads
By Steve Jones
Recently a customer asked how they could get index changes to be captured in...
By Steve Jones
giltwrights – n. the imaginary committee of elders that keeps a running log of...
By DataOnWheels
Hey folks, fun personal post today. A few weeks ago, I got married! My...
Comments posted to this topic are about the item SQL Window Functions Series: LAG()...
Comments posted to this topic are about the item Breaking Biometrics
Comments posted to this topic are about the item Attaching Databases