11
I have several tables that already exist in my database. Some of them have quite a few columns.
I want to make some stored procedures to do a merge statement with these tables. To do that I would like the parameter of the stored procedure to be a User Defined Table type.
I can go script out each table and modify it to a User Defined Table Type Creation statement.
But what I would really like is a way to generate a user defined table type off an existing table in my database. I could then add that script to my database build (and then adding new columns to a table does not need more than one edit).
Is there a way to do that? Or should I just get busy scripting my tables out?