Working with User-Defined Types in SQL Server
Applies to: SQL Server
You can access user-defined type (UDT) functionality in Microsoft SQL Server from the Transact-SQL language by using regular query syntax. UDTs can be used in the definition of database objects, as variables in Transact-SQL batches, in functions and stored procedures, and as arguments in functions and stored procedures.
In This Section
Defining UDT Tables and Columns
Describes how to use Transact-SQL to create a UDT column in a table.
Manipulating UDT Data
Describes how to use Transact-SQL to work with UDT data in SQL Server.
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for