Results 1 to 2 of 2

Thread: collation name

  1. #1
    Join Date
    Feb 2004
    Location
    michigan
    Posts
    17

    Unanswered: collation name

    Is there any way, I can query across all objects in a given database for what is the current collation name for each column in an object?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Code:
    select [Object_Name]=object_name(id), 
    	[Column Name]	= name,
    	[Collation]		= collation
          from syscolumns 
          where objectproperty(id, 'ismsshipped') = 0 
          order by object_name(id), colid

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •