SQL Server Performance

Change View column collation

Discussion in 'SQL Server 2005 General DBA Questions' started by jbharani, Mar 7, 2008.

  1. jbharani New Member

    guys,
    I recently migrated one database from sql 2k to sql 2k5. Now the problem is I have to change the view column collation can anyone help me in solving this.
    Thanks,
    Baru.
  2. Mawla New Member

    Do u mean you have a view and you want to change the collation of one of its columns ?
    If so , you can edit the view and specify the column collation using COLLATE Keyword
    ALTER VIEW Dbo.v1
    AS
    SELECT
    col1 collate Latin1_General_CI_AS ,
    col2
    from tbl1

  3. pritesh.akhani New Member

  4. pritesh.akhani New Member

  5. satya Moderator

    Pritesh
    What this supposed to mean?

Share This Page