Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Thava

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Get all the Child Tables up to N level

Get all the dependent tables for a master table up to N level(Till the leaf ) you can either find dependency or you can find all the child tables.  Read more...
By Thava 2013/09/23 | Source: SQLServerCentral.com | Category: foreignkey
Rating: |  Discuss |   Briefcase | 1,122 reads

Script for no of Index in a table

This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.  Read more...
By Thava 2012/11/23 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 857 reads
   Items 1 to 2 of 2