locked
How to create User defined Table Types from existing Table RRS feed

  • Question

  • 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

    Friday, October 14, 2016 1:46 PM

Answers

  • 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

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Manish Joisar Friday, October 14, 2016 4:48 PM
    Friday, October 14, 2016 4:10 PM
    Answerer