Forcing integrity between tables and procedures

You can force integerity between tables and views with schemabinding when you create views so that tables cant be dropped until views that bind on tables are dropped. Unfortunately it is not possible to force this integrity between tables and procedures. Tables can be dropped though there are procedures referencing them But if you use SQL Server 2005 or higher version, it is possible with DDL trigger which is one of finest features available CREATE TABLE test_table ( code int , names varchar ( 100...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/01/17/3238.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3238" width="1" height="1">