• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. SQL Server Tables and Databas... > Working with User-Defined Data Types

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 required information and click OK.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint