Out of curiosity, what do you need the database  schema for? Typically best
practice is to only access information stored within the confines of
SharePoint through the SharePoint API. If you attempt to do otherwise, you
have a good chance of inadvertently wiping something out which will cause
your SharePoint platform to cease to operate properly.

I am curious to know where the actual content of a page that i am displaying
on my site is stored.

For example I have Basic page called "Helloworld.aspx" and write text on the
page which says " This is a test to see where the content is stored".

I would like to know where exactly this content of " This is a test to see
where the content is stored" is stored in the database.

In sharepoint  2003 it used to be stored in a column called "Content" in the
dbo.docs table of the content database.

For sharepoint 2007  the table is named as dbo.AllDocs.
I am unable to figure out which column the content is stored because the
structure of the tables is changed for sharepoint 2007.

Hope this answers your query.

Let me know if anyone has an answer to my original question.

It looks to me like it's in a child table. If AllDocs.HasStream =1 then
join on AllDocStreams.ParentID = AllDocs.Id? Just guessing - I haven't
tried it. I plan to stay out of Management Studio and learn the
SharePoint API instead (eventually...).

Yup,your right,.Its stored in the AllDocStreams Table.
but it should be AllDocStreams.Id =AllDocs.Id and AllDocs.HasStream =1

Though it's not a complete schema, but you will get some understanding
at database  level of which content database is using for each
webapplication, personalsites, and ssp.

If you open back up interface in central administration, you can see the
databases list. It will give database name for each web application.

I don't know about other way of looking database name for each web
application.

When i say database  schema ,i am not looking at the database names of the web
applications. I am looking at the actual table structures in the content
database and how exactly the data is stored.

Microsoft has schema  definition for Sharepoint 2003 but i am unable to find
for 2007.

So I'm going to suggest something revolutionary...

Open up SQL server and look.

This is the link for the 2003 version of database  tables.
msdn2.microsoft.com/en-us/library/ms998452.aspx

I did look up in the SDK but havent found any.

I said if you really want to know, open up SQL Server Management Tools and
open the database  and the tables to view the schema. Be warned though as
Michael mentioned that you're on your own if something breaks.

I have done that too and I am not able to find the column in AllDocs that
suggests it is the field which contains the actual content of the pages and that
was the reason i am asking for description of the database  tables and fields for
sharepoint 2007.

I've looked recently as well ...I believe it must have been removed from the
SDK docs.

Also, the MS product group (esp. product support) is getting very hard core
about people mucking with the WSS databases. Checkout this KB article
published on April 6: http://support.microsoft.com/kb/841057/en-us

Basically if you (or a 3rd party product you install) directly touches the
database, you're on your own.