다음을 통해 공유

Checks Collection

  • 아티클

Microsoft SQL Server의 이후 버전에서는 이 기능이 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 수정하십시오.

The Checks collection contains Check objects that expose Microsoft SQL Server integrity constraints defined on the columns of a table.

현재 개체를 보여 주는 SQL-DMO 개체 모델

Methods

Add Method

Remove Method (Collections)

Refresh Method

 

주의

With the Checks collection, you can:

  • Define an integrity constraint on a SQL Server column.
  • Remove an existing constraint from a SQL Server column.

SQL Server integrity constraints can be defined as part of a CREATE TABLE or ALTER TABLE statement.

When creating a SQL Server table using the Table object, an empty Checks collection is created as part of the Table object creation. Adding Check objects to the Checks collection adds constraint definition text to the CREATE TABLE statement generated when the Table object is added to the Tables collection of a Database object.

If a Table object references an existing SQL Server table, changes to the Checks collection generate ALTER TABLE statements.

For more information about creating integrity constraints, see Check Object.

To remove a CHECK constraint

  1. Get the desired Table object from the Tables collection of a Database object.

  2. Use the BeginAlter method of the Table object to mark the beginning of changes to the SQL Server table.

  3. Use the Remove method of the Checks collection of a Table object. Indicate the targeted integrity constraint using the constraint name or the ordinal location in the collection, as in:

    oTables("Order Details").Checks.Remove("CK_Order Details_Discount")

  4. Use the DoAlter method of the Table object to submit the changed table definition to SQL Server.

참고 항목

관련 자료

ALTER TABLE(Transact-SQL)
CREATE TABLE(Transact-SQL)

도움말 및 정보

SQL Server 2005 지원 받기