User Datatypes Editor (SQL Server)

From DBArtisan
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The User Datatypes Editor lets you modify the base datatype, rule and default bindings, and referencing or referenced objects for a user datatype.

To edit a user datatype

  1. Open an editor on the user datatype. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

In addition to letting you change the Schema, this tab lets you work with settings in the following categories:

Base Datatype

Lets you modify the Type and Allow Nulls properties. Depending on the Type selected, Precision, Scale, or Size properties are available as appropriate.

Bindings

Default Binding - Lets you select a default. For information on creating defaults, see Defaults Wizard (SQL Server). Rule Binding - Lets you select a rule. For information on creating rules, see Rules Wizard (SQL Server).

Usage

Lets you manage database objects referencing or referenced by a user datatype. Objects are grouped within object type folders. Optionally, you can:

Select an object and click Edit to open an object editor on the selected object.

Select an object and click Drop to initiate dropping the selected object.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.