| Subject | Re: Create views in prod fdb based on a sample fdb |
|---|---|
| Author | venussoftop |
| Post date | 2010-01-02T05:18:09Z |
Hi all
I think I have it ironed out as far as dependent views are concerned.
*** look for dependencies
TEXT TO lcSQL TEXTMERGE NOSHOW PRETEXT 6
SELECT *
FROM rdb$dependencies
WHERE rdb$field_name IS NULL
AND rdb$dependent_name = '<<ALLTRIM(tcViewName)>>'
AND rdb$depended_on_type = <<tnType>>
ORDER BY rdb$depended_on_name
ENDTEXT
Cheers!
Kind regards
Bhavbhuti
I think I have it ironed out as far as dependent views are concerned.
*** look for dependencies
TEXT TO lcSQL TEXTMERGE NOSHOW PRETEXT 6
SELECT *
FROM rdb$dependencies
WHERE rdb$field_name IS NULL
AND rdb$dependent_name = '<<ALLTRIM(tcViewName)>>'
AND rdb$depended_on_type = <<tnType>>
ORDER BY rdb$depended_on_name
ENDTEXT
Cheers!
Kind regards
Bhavbhuti