User defined table types for column types

Hi!

Is it planned that you can use user defined table types as column types when you create a new table?

In the current CTP (June CTP) it is not working...

Thanks

Klaus Aschenbrenner

http://www.csharp.at

http://www.csharp.at/blog

[413 byte] By [KlausAschenbrenner] at [2008-1-22]
# 1
BOL says explicitly that user defined table types only can be used as variables and parameters to procs/functions. I take that as a no.
OleKristianBangaas at 2007-10-3 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Database Engine...
# 2

"Nested" relational data can only be implemented using XML. The Table valued parameters can only be used as parameters.

Jens K. Suessmeyer.

http://www.sqlserver2008.de

JensK.Suessmeyer at 2007-10-3 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Database Engine...

SQL Server Katmai

Site Classified