List of all Columns of one Table

SELECT
    COLUNAS.NAME AS COLUNA,
    TIPOS.NAME AS TIPO,
    COLUNAS.LENGTH AS TAMANHO,
    COLUNAS.ISNULLABLE AS EH_NULO

FROM
    SYSOBJECTS AS TABELAS,
    SYSCOLUMNS AS COLUNAS,
    SYSTYPES   AS TIPOS
WHERE
    TABELAS.ID = COLUNAS.ID
    AND COLUNAS.USERTYPE = TIPOS.USERTYPE
    AND TABELAS.NAME = 'TBL_TESTE'