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

change Primary key of a access table

P: n/a
How can i turn a primary key off on a access table with a sql statement.

thank for reply's
Apr 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Willy Rubens wrote:
How can i turn a primary key off on a access table with a sql statement.


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

ALTER TABLE <table name> DROP CONSTRAINT <primary key name>

In Access the usual name of a PK constraint is "PrimaryKey."
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBRFE4B4echKqOuFEgEQK9JwCgz7OJrYyLCCQ2YBu1OruJAV mn7gAAoJga
ZcL7nCUfE3mOiJ9a4NB8Ol78
=kcYo
-----END PGP SIGNATURE-----
Apr 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.