in

System.Data.SQLite

An open-source, enhanced version of the SQLite database engine for Windows
System.Data.SQLite » SQLite Database Engine » General » delete a field from table

delete a field from table

Last post 09-25-2007 8:17 AM by Robert Simpson. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 09-20-2007 3:10 AM

    • wesam23
    • Not Ranked
    • Joined on 09-20-2007
    • Libya
    • Posts 1

    delete a field from table

    Reply Contact

    Hi every one,

    first, thanks to the "ADO.NET 2.0 Provider for SQLite" Team for the great work they did.

    My question about how to delete a field (column) from the table structure?! I've worked with MySQL, and I know that it could be done by ALTER. but in SQLite they said that this command doesn't support deleting fields!!!

    Is there any way to do it, other than deleting the table and re-create it with the new field removed!!!

    Thanks in advance... 

    Web Developer, VB.net programmer.
    OeaWeb.com

  • 09-25-2007 8:17 AM In reply to

    Re: delete a field from table

    Reply Contact

    Unfortunately no.  SQLite is notoriously light on the schema-modifying front.

    Robert

     
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems