EXEC master..sp_MSForEachDB '
IF EXISTS 
( 
SELECT 1 
FROM [?].INFORMATION_SCHEMA.tables 
WHERE table_NAME = ''vw_fctmemberdetail_ca'' 
) 
BEGIN 
SELECT ''[?]''; 
SELECT ''['' +table_CATALOG + '']'', ''['' + table_NAME + '']'' 
FROM [?].INFORMATION_SCHEMA.tables 
WHERE table_NAME = ''vw_fctmemberdetail_ca''; 
END';
No comments:
Post a Comment