السلام عليكم ورحمته الله وبركاته
هو سؤالى فى view ايه معنى انى استخدام الامر دا فى انشاءة WITH SCHEMABINDING
دا معناه ايه
السلام عليكم ورحمته الله وبركاته
هو سؤالى فى view ايه معنى انى استخدام الامر دا فى انشاءة WITH SCHEMABINDING
دا معناه ايه
From msdn:
SCHEMABINDING
Binds the view to the schema. When SCHEMABINDING is specified, the select_statement must include the two-part names (owner.object) of tables, views, or user-defined functions referenced.
Views or tables participating in a view created with the schema binding clause cannot be dropped unless that view is dropped or changed so that it no longer has schema binding. Otherwise, SQL Server raises an error. In addition, ALTER TABLE statements on tables that participate in views having schema binding will fail if these statements affect the view definition.
Mohamed Meshref
Software Design Engineer
SQL Server Team
Microsoft Corporation, Redmond HQ
Phone: +1-(425)704-8684
Mobile: +1-(425)445-7386