The Wiert Corner – irregular stream of stuff

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

  • My badges

  • Twitter Updates

    • @redrapids Factorial calculator. 27 minutes ago
    • RT @ZusterMerel: Echt, kan het iemand nog schelen? Same shit, different day. En over 2-4 jaar weer dezelfde verkiezingen met een waardeloze… 30 minutes ago
    • RT @isotopp: Dreizig Milliarden Euro kostet der Wiederaufbau nach der Flutkatastrophe im Ahrtal, und die weggespülten Häuser sollen nicht a… 35 minutes ago
    • RT @aliettejonkers: "Hospital infection study shows use of FFP3 respirators at Addenbrooke’s ‘may have cut ward-based infection to zero’" 36 minutes ago
    • RT @isotopp: InfraCGI zeigt Euch andere Straßen. Wandel ist möglich. Farbe reicht nie. Dem Auto muß in der Stadt Platz entzogen werden. 36 minutes ago
  • 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,469 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 »

%d bloggers like this: