Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#38 ALTER TABLE RENAME TO

closed-invalid
nobody
None
5
2005-06-06
2005-06-01
Anonymous
No

Hi,

the following SQL command will be accepted by the
sqlite3 console but not by SQLiteCommand.ExecuteNonQuery():

ALTER TABLE Xyz RENAME TO 'Abc'

ExecuteNonQuery() throws an exception:
"near "ALTER": Sytnax Error"

Would you please let me rename tables?

thanks,
Karsten Meier

Discussion

  • Robert Foster
    Robert Foster
    2005-06-06

    • status: open --> closed-invalid
     
  • Robert Foster
    Robert Foster
    2005-06-06

    Logged In: YES
    user_id=526041

    This functionality is dependent on the version of the sqlite
    dll you are using. SQLite.Net ships with an older version
    of the dll that doesn't support ALTER TABLE syntax. Please
    update with a newer version on the sqlite.org web site and
    try again. If you are still having issues with the newer
    version, then feel free to re-open this bug.