You can identify tables that store a GUID (Globally Unique Identifier) value with the following script:
SELECT [table] = s.name + N'.' + t.nameFROM sys.tables AS tINNER JOIN sys.schemas AS sON t.[schema_id] = s.[schema_id]WHERE EXISTS(SELECT 1 FROM sys.columns AS cWHERE c.[object_id] = t.[object_id]AND c.system_type_id = 36 -- uniqueidentifier);
Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.
