Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Necesito cambiar el nombre de campos
Message
From
13/01/2004 20:10:15
Alex Feldstein
Florida, United States
 
 
To
13/01/2004 18:39:18
Raymundo Munoz Leyva
Pesip
Mexico City, Mexico
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Necesito cambiar el nombre de campos
Miscellaneous
Thread ID:
00866540
Message ID:
00866558
Views:
16
>SELE 1
>use
>ALTER TABLE ana_mpio.dbf RENAME COLUMN nue_campo TO nom_campo NOVALIDATE


  • Debes abrir la tabla en forma exclusiva

  • No existe RENAME COLUMN en ALTER TABLE

  • Haz un ADD COLUMN y copiar los datos si los hay (con REPLACE)

  • Luego un DROP COLUMN de la columna vieja


    • Alex Feldstein, MCP, Microsoft MVP
    VFP Tips: English - Spanish
    Website - Blog - Photo Gallery


    "Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
    Previous
    Next
    Reply
    Map
    View

    Click here to load this message in the networking platform