On Tue, May 06, 2003 at 12:38:59 -0400,
Israel Calderon <icalderus(at)hotmail(dot)com> wrote:
>
> Hello I am currently analyzing a db schema and ran across something which I
> am not familiar with. The table name within the create statement is
> enclosed within double quotes as well as a column within the table. Heres
> the format:
>
> CREATE TABLE "xyz"(
> act_act character varying (40),
> "action" character varying (30),
> st_id uniqueidentifier DEFAULT newid() NOT NULL
> );
>
>
> The "xyz" and "action" portions of this create statement I do not
> understand. Can anyone elaborate on this? Much appreciated!
Quotes allow you to preserve case in the name, use some special charcters
that you couldn't use without quoting or use reserved words for the names.