User Guide > Definition Sets > About Definition Sets
 
About Definition Sets
A definition set is a set of definitions you create that can be shared by other TDV resources. A definition set includes SQL data types, XML types, XML elements, exceptions, and constants. You can refer to the resources in a definition set from any number of procedures or views. The changes you make in a definition set are propagated to all the procedures or views using the definition set. You cannot publish a definition set. The definition sets you create are reusable and can be shared with any user with appropriate access privileges in the system.
TDV supports three types of definition sets:
XML-based
SQL-based
WSDL-based
TDV supports these definition sets with the following data types and arrays of those types:
BINARY, BLOB, VARBINARY, DECIMAL, DOUBLE, FLOAT, NUMERIC, BIGINT, BIT, INTEGER, SMALLINT, TINYINT, CHAR, CLOB, LONGVARCHAR, VARCHAR, DATE, TIME, TIMESTAMP, CURSOR, ROW, XML
 
Studio has an editor for building and editing definition sets. The definition set editor opens automatically when you create a definition set. For details, see Creating a Definition Set. At any time, you can open the definition set in the editor by double-clicking the definition set in the resource tree.