CREATE TABLE with dup keys

[Rafy]

To the best of my knowledge, you cannot do that on a table (physical file). However, you can create a table with with no primary or unique keys and then create an index (logical file) specifying the field(s) that make up the key. In essence "omitting" the UNIQUE keyword.

[Necqui]

CREATE TABLE with dup keys

How do I Create a Table in SQL that allows duplicate key values. I am looking to create the following in SQL. Note: I'm not using the UNIQUE DDS keyword.

---

Code