Datalink Feedback VI: Semantics

Gerard Lemson lemson at MPA-Garching.MPG.DE
Fri Apr 25 02:20:11 PDT 2014


HI
> On Fri, 25 Apr 2014, Markus Demleitner wrote:
> 
> > Dear list,
> >
> > On Thu, Apr 24, 2014 at 09:29:43AM -0700, Patrick Dowler wrote:
> > > Q. I did create a table with a column named "property" in postgresql
> > > and sybase with no issues and didn't find it in the list of SQL
> > > reserved words I checked... does anyone anticipate issues renaming
> > > the "semantics" field to "property"?
> >
> > A quick interaction with the search engine of my choice would suggest
> > property is a safe column name.
> >
> > Still, if everyone could just briefly run
> >
> >   create temp table autodropped (property real)
> 
MS SQLServer 2012 OK ("create table #autodropped(property real)" AND "create
table autodropped(property real)")

Gerard



More information about the dal mailing list