Working with User-Defined Data Types
User-defined data types allow you to further refine the data types provided by SQL Server. A user-defined data type is a combination of a data type, length, null constraint, default value, and rule. Once you define a user-defined data type, you can use it in any tables that you build. To create a user-defined data type:
1. | Right-click the User-Defined Data Types node and select New User-Defined Data Type. The User-Defined Data Type Properties dialog box appears (see Figure 5.12).
Figure 5.12. The User-Defined Data Type Properties dialog box allows you to create or modify a user-defined data type.
|
2. | Enter the ... |
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
