Disables the use of default column values for inserts on a given table.

Syntax

---

DISABLE DEFAULTS ON <TableName>

Usage

---

Use this statement to disable the use of default column values on a table. By default, default column values are enabled for all tables.

You can find out if default column values are enabled or not by querying the Tables system information table.


Examples

---

-- The following statement disables all default column values on
-- the Customer table

DISABLE DEFAULTS ON "Customer"

Required Privileges

---

The current user must be granted the ALTER privilege on the specified table in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: