---------- Original Message -----------
From: "sqlsvr" <sqlsvr@...>

> CREATE TABLE accounts
> (
> account_id INT NOT NULL PRIMARY KEY,
> account_name VARCHAR(25) NOT NULL
> );
> How do I get it show up as lowercased?

------- End of Original Message -------

create table "accounts"
(
"account_id" int not null primary key,
"account_name" varchar(25) not nul;
);

Unless you specify the table/field/procedure/parameter/... name in double-quotes,
FB assumes you mean intend it to be case-insensitive. If you do this, however,
you'll need to double-quote your identifiers everywhere:

select "account_id", "account_name" from "accounts";

-Philip