kaa
kaa

Reputation: 1367

Table definition of user type

It is possible to figure out the table definition of the user defined tabled-type?

There is no column in sys.types with such info. And sys.modules does not contains info about types.

Upvotes: 0

Views: 51

Answers (1)

Vignesh Kumar A
Vignesh Kumar A

Reputation: 28403

Try this

   SELECT *
    FROM sys.columns
    WHERE object_id IN (
      SELECT type_table_object_id
      FROM sys.table_types
      WHERE name = 'some_table_type'
    );

Upvotes: 1

Related Questions