Re: sql syntax

} Subject: sql syntax } Date: Tue, 11 Oct 1994 08:26:18 GMT } Reply-To: alex@arcfan.demon.co.uk (Alex McLintock) } Organization: Naxela Concepts } } I am having trouble with the following sql statement: } } create table reside (reside char(35), address text , htype decimal(6) ) } } I guessed type might have been a reserved word and so changed } it to htype. Might address be a reserved word? Where in the manuals } do I find a list of reserved words or can columns have any } name? } } Please email replies as I might miss any posted... } } Thanks } } AlexMC [ also alex@arcfan.demon.co.uk ] } Appendix C of the SQL User Guide has a list of reserved words, in ver 4.00. Things in the docs sometimes move around a bit by version, but check the appendices of the User Guide. You don't mention whether you are running SE or OnLine. Text data type is not supported in SE. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\