the complete of reserved words Q

Question

the complete of reserved words Q

humorist66

SSC Enthusiast

Points: 167
More actions
May 15, 2003 at 8:01 pm

#159148

some sql reserved words are very long.
such as
add constraint .... foreign key(...)
references ....(...)
in foxbase, we can write "constr" as "constraint" and "refere" as "references"
is there rules on the short written of sql reserved words?

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

RD Francis SSCarpal Tunnel Points: 4867 More actions · Answer 1

I you look up "reserved" in SQL Books Online, all keywords are listed, and abbreviations are included. For instance, you can find both TRAN and TRANSACTION.

Also, the description/syntax page for each command notes if a shortened version is available.

I am unaware of a specific list of abbreviated commands, but then I didn't really look for it.

RD Francis

R David Francis

RD Francis SSCarpal Tunnel Points: 4867 More actions · Answer 2

With another quick glance through, the only ones that jump out are:

TRAN for TRANSACTION

EXEC for EXECUTE

PROC for PROCEDURE

RD Francis

R David Francis

Richard Binnington SSChasing Mays Points: 656 More actions · Answer 3

You can always start typing the word in Query Analyzer and see when the word turns blue