Re: Database internals

From: Jim Connelley <jamespc_at_NOSPAM.pdq.net>
Date: Sat, 21 Jul 2001 23:26:06 GMT
Message-ID: <CFB0720DB022CB41.5328F65B87BEF0DA.6F5D09C77AB28481@lp.airnews.net>

On Thu, 24 May 2001 10:48:36 +0200, "Darius Blaszijk" <dblaszijk_at_zonnet.nl> wrote:

>Hello there,
>
>Does anybody know where to get more information on how a database works?? I
>don't mean SQL or a discription on relational databases. No, I mean
>information on how a database keeps track of the records it holds. How does
>it handle the various types and how is a typical API built up? Stuff like
>that.
>Is there such a site I could use to study the database concepts?
>
>Many thanks, Darius Blaszijk
>
>

Many database work by tracking your database objects, columns, indexes etc. in their own master or SYSTEM database. Try this query (MSSQL 7.0)

select sysobjects.name,                              
       syscolumns.colid,                             
       syscolumns.name,                              
       systypes.name,                                
  from sysobjects,syscolumns,systypes                
 where sysobjects.id = syscolumns.id                 
   and syscolumns.xusertype = systypes.xusertype     
   and sysobjects.id < 100                           
 order by sysobjects.id,syscolumns.colid

Does anyone have similar for other databases? Received on Sat Jul 21 2001 - 18:26:06 CDT