Access and SQLserver enable the relationship between tables and automatically update or delete the parent table data

Source: Internet
Author: User
1. Access enables the relationship between Tables and automatically deletes sub-table data after the parent table data is deleted: on the Tables interface

1. access to enable the relationship between Tables and automatically delete sub-table data from the parent table. On the Tables page, right-click "Relationships... -In the displayed Relationships window, select the expected table, and double-click the blank location in the Relationships window. In the displayed Edit Relationships window, Enforce Re is displayed.

1. AccessEnableBetween tablesLink, AndImplementationDeleteParent tableDataAutomaticDeleteSub-tableData:

On the Tables page, right-click and choose Relationships... -> In the displayed Relationships window, select the table to be joined, and double-click the blank location in the Relationships window. In the displayed Edit Relationships window, you can see the Enforce Referential Integrity option. select Cascade... now.

2. SQL ServerEnableBetween tablesLink, AndImplementationDeleteParent tableDataAutomaticDeleteSub-tableData:

Create Foreign Key-> Foreign Key pop-up window Foreign Key Relationships window-> You Can See insert and update Secification-> below is the corresponding settings. (available SQL statement settings)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.