KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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?
Tags (comma-separated)
Save Edits
Cancel