<p>I am writing a DDL script to drop a number of tables but need to identify all dependencies for those tables first. Those dependencies include foreign key constraints, stored procedures, views, etc. Preferably, I want to programmatically script out dropping those dependencies using the system tables/views before dropping the dependent table.</p>

You can use the sp_depends stored procedure to do this:
```
USE AdventureWorks
GO
EXEC sp_depends @objname = N'Sales.Customer' ;
```
http://msdn.microsoft.com/en-us/library/ms189487(SQL.90).aspx