SQL Clone
SQLServerCentral is supported by Redgate
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 2015/03/09 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 2,694 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 | 901 reads
   Items 1 to 2 of 2