dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Mar 5, 2019

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


Identify Tables Storing GUID Values

You can identify tables that store a GUID (Globally Unique Identifier) value with the following script:

SELECT [table] = s.name + N'.' + t.name
FROM sys.tables AS t
INNER JOIN sys.schemas AS s
ON t.[schema_id] = s.[schema_id]
WHERE EXISTS
(
SELECT 1 FROM sys.columns AS c
WHERE c.[object_id] = t.[object_id]
AND c.system_type_id = 36 -- uniqueidentifier
); 
Hannes Du Preez
 
Thanks for your registration, follow us on our social networks to keep up-to-date