July 7, 2005 at 3:20 pm
HI,
I have a heap of views, I have turned "bind to schema" ON on some of them, is there a SELECT statement I can use on system table that will give me a list of views that I have "bind to schema" on cause I have forgotten which ones i did (ha) !
Thanks
July 8, 2005 at 1:23 am
select * from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='VIEW' and objectproperty(object_id('[' + TABLE_SCHEMA + '].[' + TABLE_NAME + ']'),'IsSchemaBound')=1
regards,
Mark Baekdal
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
July 8, 2005 at 5:37 am
Here's another one:
select so.name, sc.text
from sysobjects so
inner join
syscomments sc on
so.id = sc.id where
so.xtype = 'v' and
sc.text like '%WITH SCHEMABINDING%'
order by name
**ASCII stupid question, get a stupid ANSI !!!**
July 8, 2005 at 1:42 pm
Thanks heaps
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply