SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Scripts by Charles Jacobus

SQLServerCentral.com profile

   Items 1 to 3 of 3   

Check Candidate Columns for FOREIGN KEY Constraints

Reports table columns that are not foreign keys but that perhaps should be.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 860 reads

Objects Referenced and Referencing

This script reports objects that are referenced by and that reference a given database object. When a column name is specified, it also includes results showing how that column is used.  Read more...
By Charles Jacobus 2013/03/07 | Source: SQLServerCentral.com | Category: maintenance
Rating: |  Discuss |   Briefcase | 842 reads

Check Candidate Columns for NOT NULL Constraints

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...
By Charles Jacobus 2013/01/23 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 690 reads
   Items 1 to 3 of 3