Removing Table Constraints in SQL Database for O-Ring Creation/Modification.
When migrating the MDTools library from an Access database to SQL, certain constraints are applied to tables. These constraints prevent users from saving new or modified data in the library. For example, the picture below illustrates the constraints imposed on the O-ring table during migration, leading to users being unable to create O-rings in the database.
To search and remove all current table constraints from the database using SQL Server Management Studio, kindly follow the steps below.
1. In Microsoft SQL Server Management Studio, right-click on the database (containing table constraints) and select New Query.
2. Copy the below highlighted query and paste on the query field.
select 'alter table ' + t.name + ' drop constraint ' + c.name
from sys.tables t
inner join sys.check_constraints c on c.parent_object_id = t.object_id
where c.name like '%disallow_zero_length'3. Execute the query. or press F5.
4. All the table constraints will appear in the result list. Now from the list, copy all the constraints and paste them in the query field (remove the previous query).
5. Execute the query. or press F5.
6. Once executed successfully, you will get message.
Follow the same steps for other database.
After removing the table constraints from the database, attempt to create the O-ring or any other data that was previously encountering issues.
Related Articles
Need to manually define planes to define single body CAD models to set Assembly Constraints
Unable to directly set constraints for single body CAD models by using MDTools the Assembly Constraints command. It displays the following message. How to fix this? To constrain the single body: Define the axis, Manually define the plane, click ...How can I get MDTools Library Manager to read custom outlines correctly?
Tips on preparation of custom outlines: Save the document as a text file in a desired location. Be careful selecting the center point when reading from the drawing file. Make sure your arcs are broken up into 180 degrees or less as MLM cannot ...Users are unable to use shared Networked Library(Access Database) with MDTools.The";file already in use" or another message displays.
To solve the issue, refer Microsoft-Office-Access-Update-causes-issues-with-MDTools-and-HyDrawCAD-accessing-a-Network-Library-Solutions.pdfUsers are unable to use the shared Networked Library (Access Database) with MDTools. The";file already in use"or another message displays.
To solve this issue, refer Microsoft-Office-Access-Update-causes-issues-with-MDTools-and-HyDrawCAD-accessing-a-Network-Library--Solutions.pdfMDTools find the Library (Applicability MDTools 700 Series)
"Could not find library database. Please specify correct path." If MDTools cannot find the library, ensure the following: Ensure that the MDTools library path is set correctly. - Go to MDTools options > Library path - Set the file path to your ...