Re: Create view or index with a constraint

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Tim

You have to create the index by itself using CREATE TABLE and put the 
constraint on the table by itself using ALTER TABLE - they are separate, 
conceptually unrelated things.

Vern

On 10/12/2020 4:03 PM, Tim Feldmeier wrote:
> Hello, I wanted to create an Index of a table with a different key as well as have a constraint to account# > 500000 .
> Does anyone have an example for this.
>
>
>
>
> Thank You
>
> Tim Felmeier
> Programmer Analyst For Coyote System
> Roadrunner Transportation Systems
> 1431 Opus Place, Suite 530
> Downers Grove, IL 60515
> Phone# (331)-2337921
>
>
> The information transmitted is intended only for the person or entity to which it is addressed and may contain proprietary, business-confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you received this in error, please contact the sender and delete the material from any computer.