Microsoft SQLServer/Reporting Services 6. 1. 2012 EN

How to find data types in Microsoft SQL Server

Jednoduchý T-SQL postup, jak v Microsoft SQL Serveru dohledat tabulky a sloupce podle konkrétního datového typu.

To find the data types in SQL Server can take advantage of the Transact-SQL script:

SELECT DISTINCT
QUOTENAME(OBJECT_SCHEMA_NAME([object_id]))
+ ‘.’ + QUOTENAME(OBJECT_NAME([object_id]))
FROM sys.columns
WHERE [system_type_id] = 98;

where system_type_id is the definition of search datatype.
What is your data type id can be detected with this SELECT:

SELECT xtype, name
FROM systypes
ORDER BY xType