Para se descobrir quais os campos fazem parte de uma tabela, pode-se executar a query abaixo modificando apenas o nome da tabela:

SELECT SC.Name As ‘Colunas’ FROM SysObjects SO
INNER JOIN SysColumns SC ON SO.id = SC.id
WHERE SO.Name=’NomeDaTabela’

[]‘s

This entry was posted on quarta-feira, janeiro 7th, 2009 at 7:32 and is filed under MS SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.