From: Jonathan on
lol... I see that the first thing I need help with is spelling

Jonathan

"Jonathan" wrote:

> Hi, using a migration tool to convert an MS Access database to MS SQL 2005 I
> have found that tables now have a constraint that I do not require. The
> constraint is consistently named 'SSMA_CC$...$disallow_zero_length'.
>
> I would like to run a select statement to list all the tables/columns that
> have this constraint to confirm that the conversion created this constraint.
> I would then like to drop this constraint.
>
> Any ideas or suggestions appreciated. :-)
>
> Many thanks,
> Jonathan