Setting column length in sql ?

[Tom Corcoran]

Please let me know if there is a more suitable group to post in.

In query analyzer I do :

alter table mytable
add mycolumn varchar default 50

But when I check in Enterprise manager the column has a length of 1 rather
than 50.

What am I doing wrong?

Thanks.

Cheers - Tom.

"Do you know what a metaphysical can of worms this portal is?" Craig
Schwartz, Being John Malkovich (1999)

[Joe Celko]

You need to give a length; VARCHAR by itself is the same as VARCHAR(1).

--CELKO--
===========================
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, datatypes, etc. in your
schema are.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Simon Hayes]

"Tom Corcoran" <to*****************@nospam.btinternet.com> wrote in message
news:bu**********@titan.btinternet.com...

Please let me know if there is a more suitable group to post in.

In query analyzer I do :

alter table mytable
add mycolumn varchar default 50

But when I check in Enterprise manager the column has a length of 1 rather
than 50.

What am I doing wrong?

Thanks.

Cheers - Tom.

"Do you know what a metaphysical can of worms this portal is?" Craig
Schwartz, Being John Malkovich (1999)

I think you're probably looking for this:

alter table mytable add mycolumn varchar(50)

Your code adds a new varchar(1) column with a default integer value of 50.

Simon

[Tom Corcoran]

> alter table mytable add mycolumn varchar(50)

Your code adds a new varchar(1) column with a default integer value of 50.

Thanks guys, that's it. tom.