DataTamer: SQL Server Services

List All Column DataTypes

The following code will list every column in a database and its datatype for review.

SELECT
	T.[name] AS [table_name]
	,C.[name] AS [column_name]
	,Ty.[name] AS [datatype_name]
	,C.[precision]
	,C.[scale]
FROM
	sys.tables AS T
	INNER JOIN sys.columns AS C
		ON T.object_id = C.object_id
	INNER JOIN sys.types AS Ty
		on C.user_type_id = Ty.user_type_id
ORDER BY
	Ty.name
	,C.name
	,T.name

Code

© All rights reserved. DataTamer Inc. 2012