Adicionar Unique com validação de campo NOT NULL SQL
21 de abril de 2021 | by administrador
CREATE UNIQUE NONCLUSTERED INDEX [unique_tb_my_table_field] ON [tb_my_table]
(
vch_my_field ASC
)
WHERE [vch_my_field] IS NOT NULL
GOCREATE UNIQUE NONCLUSTERED INDEX [unique_tb_my_table_field] ON [tb_my_table]
(
vch_my_field ASC
)
WHERE [vch_my_field] IS NOT NULL
GO