The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 2,318 other followers

Archive for August 13th, 2009

InterBase/Firebird – query to show which fields in your database are not based on a domain

Posted by jpluimers on 2009/08/13

Our strategy is that in all of our InterBase and Firebird databases, the column definitions are based on domains.

But some of our databases do not have that for all columns (usually because we got involved later in the development cycle).

When you forget to define a column based on a domain, then both InterBase and Firebird will create a new system domain on the fly that starts with ‘RDB$’.
So if you forget, you get a new system domain for every column!

The below query will list those columns. Read the rest of this entry »

Posted in Database Development, Development, Firebird, InterBase | 4 Comments »

InterBase/FireBird – querying the system tables to get your actually used field/column types

Posted by jpluimers on 2009/08/13

Shortly, I’ll post a blog entry about find out which columns are not based on domains.
In order get the right definition for those domains, I needed a way to get that info from the DB, preferably in a SQL-statement (that saves you starting your application development environment).

The SQL-statement is based on my initial browsing of these documents:

If you find errors or omissions, please let me know.

So here it is:
Read the rest of this entry »

Posted in Database Development, Development, Firebird, InterBase | Leave a Comment »

 
<span>%d</span> bloggers like this: