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) NOT IN (SELECT * FROM ( VALUES ('DHISTITEM'),('DHISTLAF'),('DHISTNATUREZA'),('DLDC'),('DNORMAREFERENCIADA'),
	               ('DPERIODO'),('DRELATORIO'),('GCONSSQL'),('GFORMULA'),('RCAMREL'),('RRELAT'),('TPAR'),('TPRDHISTORICO'),('GFILTROS'),
	               ('GIMAGEM'),('GJOBLOG'),('GJOBQUEUE'),('GJSJOBS'),('GJSLOGS'),('GJSPARAMETERS'),('GLBCONCEITOSIMPORTACAO'),('GMAILFILA'),
	               ('GMAILSEND'),('GMAILSENDATTACH'),('GPARTSUSRPARTPARAM'),('GUSRPAR'),('GVALDEFAULT'),('RIMGREL'),('RRELTIP') ) LISTAEXCLUDE (TABELAS))
          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