vdespa.de

Jump to comments

So you have in front of you a huge database with thousands of tables and you want to find all the tables that have a certain field.

SELECT *
FROM RDB$RELATION_FIELDS
WHERE RDB$FIELD_NAME = "FILED_YOU_ARE_LOOKING_FOR"

We also assume that the field name has on all the tables the same name.

You may also want to use wildcards.

References

comments powered by Disqus


Developers

Generate Excel documents from your custom Joomla component in seconds. Library download and quick start guide is available.

View details »

Site builders

Generate Excel documents from your custom Joomla component in seconds. Library download and quick start guide is available.

View details »

Users

article.md brings to Joomla! the power of Github & co. combined with a lightweight markup language, Markdown.

View details »