I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

Interbase Metadata

Interbase Metadata in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: Interbase   Metadata   Interbase Metadata  
andreK
 (Inactive)
Balikpapan, AK ID
In the Isql tool the user is able to get metadata on an object that resides in the databse. How is this done. Is this stored in a file somewhere?
 Posted 20 years ago (Thread Starter)
Comment Quote
About andreK -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1094, 5 replies
Thread Started 2/23/2001 11:23:00 AM
View Counter=3947
Last Reply Posted 2/28/2001 8:59:00 AM)
Location=Balikpapan, AK ID 
Joined=15 years ago   MB Posts=15  
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
Not exactly a file...it's stored in the database dictionary, which is kept in the RDB$ standard tables in each InterBase database.

These tables can be queried to produce the metadata that ISQL provides. I run across these queries many times on the InterBase forums posts on developers.href.com.


------------------
Scott Wehrly
Software Engineer
swehrly@prestwood.com
 Posted 20 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1096 (Level 1.1)  Reply to 1094
Thread Started 2/23/2001 12:02:00 PM
View Counter=2
Location=Las Vegas, NV USA 
Joined=19 years ago   MB Posts=442   KB Posts=19  
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
Yes, that's the contents of the BLOB field called RDB$VIEW_SOURCE in the RDB$RELATIONS table. ISQL merely fetches the BLOB contents and displays them as-is.

The Database Explorer tool does the same thing when you click the "Text" tab for a table or a view.



------------------
Scott Wehrly
Software Engineer
swehrly@prestwood.com
 Posted 20 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1098 (Level 1.2)  Reply to 1094
Reply Posted 2/23/2001 3:33:00 PM
Location=Las Vegas, NV USA 
Joined=19 years ago   MB Posts=442   KB Posts=19  
Most Recent Post
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
Okay, this took a while to find, due to the fact that the list servers I usually get the information from were inaccessible until this morning.

I knew that I had run across the RDB$ queries to reproduce the metadata for an InterBase table before. Here is a link to a FAQ page on the MER Systems list server that provides a good portion of the RDB$ metadata queries:

Old UBB Archived Link: [URL=http://www.mers.com/IB_0259.HTML]http://www.mers.com/IB_0259.HTML[/URL]


Look around the MER Systems FAQ site. It's "chock full" of good InterBase tips from many of the frequent InterBase gurus, like Ann Harrison, Robert Schieck, Diane Brown, etc.

The other good source for InterBase tips is the search engine at
Old UBB Archived Link: [URL=http://developers.href.com.]http://developers.href.com.[/URL]
Preface your search with "zzzINTERBASE AND" to focus on the InterBase message boards.

IHTH



------------------
Scott Wehrly
Software Engineer
swehrly@prestwood.com
 Posted 20 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1165 (Level 1.3)  Reply to 1094
Reply Posted 2/28/2001 8:59:00 AM
Location=Las Vegas, NV USA 
Joined=19 years ago   MB Posts=442   KB Posts=19  
andreK
 (Inactive)
Balikpapan, AK ID
This part I know, maybe I didn't explain myself correctly. In ISQL when you ask to show the metadat on a table or a database it shows the the sql script for it
ex

/* Database Owner SYSDBA*/
CREATE DATABASE 'c:\temp\test.gdb';

Something similar would be shown for a table

/*Table Customer owner SYSDBA*/
CREATE TABLE CUSTOMER
(
CUSTNUM VARCHAR(20),
NAME VARCHAR(50)
);

The above examples is what i would like to show. I want to show the sql code for each objects.
 Posted 20 years ago (Thread Starter)
Comment Quote
About andreK -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1097 (Level 1.4)  Reply to 1094
Reply Posted 2/23/2001 12:07:00 PM
Location=Balikpapan, AK ID 
Joined=15 years ago   MB Posts=15  
andreK
 (Inactive)
Balikpapan, AK ID
I created a database and a table, I used IBConsole to check the RDB$RElations table and also to look at the field rdb$view_source, this field showed NULL when I queried it, whats going on here?????
 Posted 20 years ago (Thread Starter)
Comment Quote
About andreK -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #1110 (Level 1.5)  Reply to 1094
Reply Posted 2/26/2001 5:56:00 AM
Location=Balikpapan, AK ID 
Joined=15 years ago   MB Posts=15  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1266A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #1094 Counter
3947
Since 4/2/2008

Follow PrestwoodBoards on: 


©1995-2021 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech