Post reply

find collation type in the tables

  • January 17, 2011 at 5:13 am

    #232310

    hi,

    there is a problem for me and i am not able to resolve it.

    there are many tables in my DB which has collation type which is other than SQL_Latin1_General_CP1_CI_AS. I want to find all the tables which doesnt have the collation mentioned above. is there any way that i can do this in a go?

    pramod

  • January 17, 2011 at 5:24 am

    #1274200

    Tables don't have a collation. Columns have a collation.

    This should get you started

    SELECT object_name(object_id) as TableName, name as ColumnName, collation_name

    FROM sys.columns

    WHERE collation_name IS NOT NULL

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 17, 2011 at 9:32 am

    #1274298

    yeah... my bad.. i mistakenly wrote it 🙂 anyways... thanks a lot... i got the answer...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply