When I am trying to run code I am getting following error,
The following errors were reported:
TypeTable service_type's second column is not a unique VARCHAR.
TypeTable provider_type's second column is not a unique VARCHAR.
I am using MS SqlServer and tables details are
table name = service_type
Column Name Data Type Allow Null
-----------------------------------------------------
service_type_id BIGINT NO -->Primary Key
description VARCHAR(255) NO
value VARCHAR(50) YES
-------------------------------------------------------------
table name = provider_type
Column Name Data Type Allow Null
-----------------------------------------------------
type_id BIGINT NO -->Primary Key
description VARCHAR(255) NO
c_id BIGINT NO
value VARCHAR(50) YES
----------------------------------------------------
I have more then 30 tables in database with similar column details but error is displaying only for above two tables only
any input ?