From: Jonathan on 12 Jan 2010 16:03 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
|
Pages: 1 Prev: How clone a view Next: Writing to exception logs with in a transaction |