This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Hello,
Is there any way to create User defined Table Types from existing table?
Otherwise, i need to create bunch of field configuration again for these table types.
Technical Project Manager cum Architect
A CREATE TABLE is similar to a CREATE TYPE ... AS TABLE.
In SSMS just do a right-mouse click on the table(s) => Script as => Create Table, and change the script to create the type(s).
Olaf Helper
