Export (0) Print
Expand All

Working with User-Defined Types in SQL Server


Applies To: SQL Server 2016 Preview

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft