CREATE TYPE Error

External Since: Jun 07, 2008 Posts: 6

When I submit this SQL statement:

CREATE TYPE AcctList AS TABLE (acct_num varchar(25))

I get an error message:

Incorrect syntax near the keyword 'AS'

What am I doing wrong?

Joe

External Since: Oct 08, 2009 Posts: 8

On 2011-10-04 17:23, Joe wrote:
>
> When I submit this SQL statement:
>
> CREATE TYPE AcctList AS TABLE (acct_num varchar(25))
>
>
> I get an error message:
>
> Incorrect syntax near the keyword 'AS'
>
> What am I doing wrong?
>
You're using the wrong version of SQL Server. User-defined table types are
supported from SQL Server 2008 onwards.

--
J.