Subject | Re: [firebird-support] Dropping a column |
---|---|
Author | Bengt Skogvall |
Post date | 2005-08-02T14:27:22Z |
Well, I do not think it is possible to change to dialect 3 with column
namens like that. Or perhaps I am mistaken?
Anyway, I was able to solve my problem using your database workbench! I
downloaded your trial and with that I could actually change the name of
the offending column. The syntax used was:
ALTER TABLE <tablename>
ALTER TIMESTAMP TO CREATETIMESTAMP
After that, dropping that renamed column was no problem!
Best regards,
Bengt
Martijn Tonies wrote:
namens like that. Or perhaps I am mistaken?
Anyway, I was able to solve my problem using your database workbench! I
downloaded your trial and with that I could actually change the name of
the offending column. The syntax used was:
ALTER TABLE <tablename>
ALTER TIMESTAMP TO CREATETIMESTAMP
After that, dropping that renamed column was no problem!
Best regards,
Bengt
Martijn Tonies wrote:
>[Non-text portions of this message have been removed]
>
> > Quoting does not help :-(. Still Token unknown.
>
> Right. This only works in Dialect 3.
>
> Change your database to dialect 3, then drop the column.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>
>
> ------------------------------------------------------------------------
> YAHOO! GROUPS LINKS
>
> * Visit your group "firebird-support
> <http://groups.yahoo.com/group/firebird-support>" on the web.
>
> * To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
> Service <http://docs.yahoo.com/info/terms/>.
>
>
> ------------------------------------------------------------------------
>