Fórum Como ver tabelas e colunas internas #532701

select distinct 
	[IdTabela] = c.object_id, 
	[Tabela] = OBJECT_NAME(c.object_id), 
	[Coluna] = c.name, 
	[Tipo] = tp.name, 
	[Tamanho] = c.max_length, 
	[Descricao] = ex.value 
	
from sys.columns c inner join sys.systypes tp 

on tp.xtype = c.system_type_id left outer join sys.extended_properties ex 
on ex.major_id = c.object_id and ex.minor_id = c.column_id and ex.name = 'MN_Description' 

where OBJECTPROPERTY(c.object_id, 'IsMsShipped')=0 
	and c.OBJECT_ID = OBJECT_ID('AFPAR_PARAMETRO') 
	and ex.class_desc = 'OBJECT_OR_COLUMN' 
	
order by OBJECT_NAME(c.object_id)