|
 |
access thread: Rename fields with ALTER TABLE in SQL Jet Access 2000
Message #1 by "Hervé PREVOST" <prevost.herve@f...> on Wed, 18 Jul 2001 12:54:13
|
|
Hello,
I try to rename fields with this sql instruction :
ALTER TABLE RENAME Field1 TO Field2
It doesn't run in ACCESS 2000 (syntax error)
How can i do it with an sql instruction ?
Thanks
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Wed, 18 Jul 2001 07:04:48 -0700
|
|
My understanding is that Jet SQL does not support renaming fields. If you
need to do this programmatically, you'll likely have to do it through ADO
extensions for DDL & security (ADOX).
Hope that's helpful.
-roy
-----Original Message-----
From: =?UNKNOWN?Q?Herv=E9?= PREVOST [mailto:prevost.herve@f...]
Sent: Wednesday, July 18, 2001 5:54 AM
To: Access
Subject: [access] Rename fields with ALTER TABLE in SQL Jet Access 2000
Hello,
I try to rename fields with this sql instruction :
ALTER TABLE RENAME Field1 TO Field2
It doesn't run in ACCESS 2000 (syntax error)
How can i do it with an sql instruction ?
Thanks
Message #3 by =?iso-8859-1?Q?Herv=E9_Pr=E9vost?= <prevost.herve@f...> on Mon, 23 Jul 2001 11:10:13 +0200
|
|
Thanks a lot you for your answer.
I must use sql instructions exclusively (questions of portability).
So, i'll use a 'select into' statement.
-Hervé
----- Original Message -----
From: "Pardee, Roy E" <roy.e.pardee@l...>
To: "Access" <access@p...>
Sent: Wednesday, July 18, 2001 4:04 PM
Subject: [access] RE: Rename fields with ALTER TABLE in SQL Jet Access 200 0
> My understanding is that Jet SQL does not support renaming fields. If you
> need to do this programmatically, you'll likely have to do it through ADO
> extensions for DDL & security (ADOX).
>
> Hope that's helpful.
>
> -roy
>
> -----Original Message-----
> From: =?UNKNOWN?Q?Herv=E9?= PREVOST [mailto:prevost.herve@f...]
> Sent: Wednesday, July 18, 2001 5:54 AM
> To: Access
> Subject: [access] Rename fields with ALTER TABLE in SQL Jet Access 2000
>
>
> Hello,
> I try to rename fields with this sql instruction :
> ALTER TABLE RENAME Field1 TO Field2
> It doesn't run in ACCESS 2000 (syntax error)
> How can i do it with an sql instruction ?
> Thanks
>
>
>
|
|
|
View Cart
