Converting column data type of SQL server view

[Alien]

Hi is it possible to change the column data type of a view in SQL server?

I have a view and would like to chance the data type from nvarchar to varchar.

Using SQL server 2008

Cheers

[Rabbit]

You can use either the cast or convert function.

[ck9663]

A view is a saved T-SQL statement. It does not actually have a data nor structure. It will use the structure of the underlying base table or whatever the result of the query (if there are explicit or implicit changes). You can always force it to what data type you want through cast and convert function. Just be aware of some values that cannot be converted to a specific data type.

Happy Coding!!!


~~ CK

[swathee]

CREATE VIEW AView
AS
SELECT CAST(Name AS Varchar(50))
FROM Table