Is it possible to change the datatype of a column in a view?

database sql-server-2008 tsql view sqldatatypes
Zolt picture Zolt · May 23, 2012 · Viewed 67.9k times · Source

Usually I run a script like this: 

ALTER TABLE [TABLE]
ALTER COLUMN [Column] NVARCHAR(40);

The result is that the field in the table gets converted to nvarchar. But what is the syntax for doing the same thing for a view? Or is that even possible?

Answer

buckley picture buckley · May 23, 2012

Sure

CREATE VIEW AView
AS
SELECT CAST(title AS char(50))
FROM titles

So check out CAST and also CONVERT on the msdn pages for full info

Related questions

Do clustered indexes have to be unique?

What happens if a clustered index is not unique? Can it lead to bad performance because inserted rows flow to an "overflow" page of some sorts? Is it "made" unique and if so how? What is the best way to …

Read More
Disable users of a database not Logins in SQL server 2008

To disable users of a Database in SQL Server 2008, I gave the command: Use Database Go Revoke Connect from username; It works for the users with SQL Server Authentication such as abcdef. But not for the user with Windows Authentication …

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More