Re: [gnome-db] Provider-Specific Reserved Words

[Rodrigo Moya <rodrigo gnome-db org>]

On Sun, 2003-08-03 at 14:29, Ian D. Stewart wrote:
> Dear List,
> 
> One of the areas where PowerDesigner (the database designer we use at work) 
> falls short is dealing with reserved words.  This is perhaps an area we could 
> address relatively simply in Gnome-DB and get a big win (IMO)
> 
> In addition to the standard SQL-92 reserved words, each RDBMS typically has a 
> number of key or reserved words it utilizes.  If we provided an interface to 
> allow the GdaServerProvider (or another class, if appropriate) to let us know 
> what those reserved words are, we could then warn the user when he/she is 
> about to assign a reserved word to a table or field.
> 
hmm, right, this is not hard to do at all. I was thinking we could
provide a SQL_WORDS schema and have providers return there the set of
reserved words.

What do you think about this?

cheers