Exibir o nome da tabela, das colunas e descrição das colunas
1: SELECT 2: SO.object_id, 3: SO.name AS NomeTabela, 4: CAST 5: (( SELECT TOP 1 6: VALUE 7: FROM sys.fn_listextendedproperty( 'NomeTabelaTraduzido' , 'schema' , 'dbo' , 'table' , SO.name, NULL , NULL ) AS fn_listextendedproperty_3) 8: AS varchar ( MAX )) 9: AS NomeTabelaTraduzido, 10: SC.column_id AS ColunaOrdem, 11: SC.name AS NomeColuna, 12: CAST 13: (( SELECT TOP 1 14: VALUE 15: FROM sys.fn_listextendedproperty( 'MS_Description' , 'schema' , 'dbo' , 'table' , so.name, 'column' , sc.name) AS fn_listextendedproperty_2) 16: AS varchar ( MAX )) 17: AS DescricaoColuna, 18: ( SELECT TOP 1 19: T.name 20: FROM sys...