SQL Server Performance

Forcing integrity between tables and procedures

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jan 17, 2008.

  1. Anonymous New Member

    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">

Share This Page