«
»
No Comments

Collation von Tabellenspalten

2009
09.22

Hi,

nach langer Abwesendheit, hier nur ein kurzes Script zum auflisten der Collation aller Tabellen-Spalten in einer Datenbank.

SELECT name, collation_name
FROM sys.columns
WHERE OBJECT_ID IN (SELECT OBJECT_ID
FROM sys.objects WHERE type = 'U')

Gruß,

Chris

Tags: ,

This entry was posted on Dienstag, September 22nd, 2009 at 15:09 and is filed under SQL Server, T-SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Your Reply