There are several ways to list dependency here is one simple way to do this.  sp_MSdependencies There are several undocumented systems stored procedures and extended stored procedures in SQL Server 2005 which can be of enormous use.  name: name or null (all objects of type)type: type number (see below) or nullif both are null, get … Continue reading Tables dependency order