Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

T-SQL's equivalent of Oracle's %TYPE operator?

When writing a procedure in PL/SQL, I can declare a parameter's type as myTable.myColumn%TYPE so that when I alter myColumn's type from say varchar2(20) to varchar2(50) I don't have to change the procedure's parameter type. Is there something similar in T-SQL?

like image 532
hli Avatar asked Dec 04 '09 20:12

hli


2 Answers

No, there is no equivalent in T-SQL.

like image 130
Derek Swingley Avatar answered Oct 24 '22 00:10

Derek Swingley


The best that you could do would be to create a user-defined data type, then you could change the underlying UDT and it would take effect in both places.

This would affect it everywhere that you use it, so if you used the type in multiple tables it would affect them all if you changed it.

like image 43
Tom H Avatar answered Oct 24 '22 01:10

Tom H