Histórico da Página

SELECT SCHEMA_NAME(C.SCHEMA_ID) ESQUEMA, 
       OBJECT_NAME(A.OBJECT_ID) TABELA, A.NAME COLUNA, B.NAME TIPO, 
       CASE WHEN B.NAME = 'IMAGE' THEN 'VARBINARY(MAX)' 
            WHEN B.NAME = 'NTEXT' THEN 'NVARCHAR(MAX)'
            WHEN B.NAME = 'TEXT' THEN 'VARCHAR(MAX)'
       END NOVOTIPO,
       CASE WHEN B.IS_NULLABLE = 0 THEN 'NOT NULL' ELSE '' END PERMITENULO
FROM SYS.COLUMNS A JOIN SYS.TYPES B 
       ON A.SYSTEM_TYPE_ID = B.SYSTEM_TYPE_ID
     JOIN SYS.TABLES C ON C.OBJECT_ID = A.OBJECT_ID
          AND SCHEMA_NAME(C.SCHEMA_ID) IN= ('DBO','TOTVSAUDIT')             
          AND OBJECT_NAME(A.OBJECT_ID) COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI IN ( SELECT TABELA COLLATE SQL_LATIN1_GENERAL_CP1_CI_AI FROM GDIC (NOLOCK))
          AND B.NAME IN  ('TEXT', 'NTEXT', 'IMAGE') 
ORDER BY OBJECT_NAME(A.OBJECT_ID), A.NAME