Alter Table statement to add field and make it unique (1 Viewer)

[Design by Sue]

I am using the following to add a column to an existing table. How do I make this column indexed with no duplicates?

db.Execute "ALTER TABLE [BrandTBL] ADD COLUMN UPCGroupName TEXT;"

Thanks
Sue

 

[Design by Sue]

Found it:

db.Execute "CREATE UNIQUE INDEX GroupName ON [BrandTBL] (UPCGroupName);"

For anyone else with this question