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

Scripts by Thava 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 2015/03/09 | Source: | Category: foreignkey
Rating: |  Discuss |   Briefcase | 2,470 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: | Category: indexing
Rating: |  Discuss |   Briefcase | 884 reads
   Items 1 to 2 of 2