At 05:47 PM 25/10/2004 +0700, you wrote:

>actually i still want to find out what is "database schema" because it
>is diferrent from 1 rdbms to another, but because i want to use firebird
>as my rdbms i think it is better if i learn what is "database schema" in
>firebird as my start.

OK,
database schema = the database and all of the structures you create inside it.

You begin with a statement like this:

CREATE DATABASE
'/path/to/the/file'
PAGE_SIZE 4092
DEFAULT CHARACTER SET ISO8859_1

which can also be written

CREATE SCHEMA
'/path/to/the/file'
PAGE_SIZE 4092
DEFAULT CHARACTER SET ISO8859_1

The statement is one of a number of SQL statements, known as Data
Definition Language (DDL) that are use to create and alter objects in a
database.

Once you have the objects, you can put data into them. That requires use
of another set of SQL statements known as Data Manipulation Language, or DML.

Where to begin? Best choice is to buy my book "The Firebird Book" which
explains everything, beginning at the beginning. I'm not kidding, it's 2Kg
of stuff you really need to know.

Next choice is to Google the Web for a document named LangRef.PDF, which
describes the whole of the SQL language for InterBase. But, first,
download the Firebird Quick Start Guide from the Firebird website.

Another good idea is to get a good SQL book. I've listed some of my
favourites at www.firebird-books.net

And join the firebird-support list, which is where you ask questions about
using Firebird and SQL.

Helen