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.
    jbharani, Mar 7, 2008
    #2

  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

    Mawla, Mar 7, 2008
    #3

  3. pritesh.akhani New Member


    pritesh.akhani, Mar 10, 2008
    #4

  4. pritesh.akhani New Member

    hjhjhjhjhj
    pritesh.akhani, Mar 10, 2008
    #5

  5. satya Moderator

    Pritesh
    What this supposed to mean?
    satya, Mar 11, 2008
    #6

Share This Page