Post reply

Table value Parameter

  • January 30, 2011 at 9:20 pm

    #233581

    Hi,

    I have created a Table value parameter as below and executed. Now where can I see this type in the database?

    create type MyTableType as table

    (

    Name varchar(150),

    City varchar(20),

    AddressID int

    )

  • January 30, 2011 at 11:06 pm

    #1280252

    Hi,

    You can see the user defined table types (UDTT) under database in which the UDTT is executed, for full path please follow the below instructions:

    Goto your database -> Programmability -> Types -> User-Defined Table Types (under this you will find the table type created by you). 🙂

  • January 31, 2011 at 11:03 pm

    #1280750

    You can query sys.table_types to get a list of all such types in a given database, and use column type_table_object_id in joins with other views (e.g. sys.columns) to get more detailed information.

  • February 1, 2011 at 12:28 am

    #1280777

    This is also a good way to find User defined data/table types.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply