By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,461 Members | 2,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,461 IT Pros & Developers. It's quick & easy.

sql query

P: n/a
Hi,
I wanted to know if there is anything wrong with this query?
I'm having a problem running it.
thanks,
smriti
ALTER TABLE disability_organizations RENAME COLUMN organization_id TO
disability_organizations_id;
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Smriti Dev wrote:
Hi,
I wanted to know if there is anything wrong with this query?
I'm having a problem running it.
thanks,
smriti
ALTER TABLE disability_organizations RENAME COLUMN organization_id TO
disability_organizations_id;


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

If you're using a JET db (the Access mdb database engine) then there
isn't a "RENAME COLUMN" command (actually, I've never seen it in any
other db's SQL statements). You'll have to create a new column w/ the
same data type, but a different name - copy the original column's data
into the new column - delete the old column.

- --
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP6v8AIechKqOuFEgEQLf5QCg8gLV/rKEk9Bum4MUer/9La+z6Z8An2xx
hGpcIq3dGbGUrgH+I8cfzB3p
=a/VN
-----END PGP SIGNATURE-----

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.