SQL – Get the list of columns of a table

This can be done by querying the system tables of SQLServer

 

SELECT   
    SysObjects.[Name] as TableName,   
    SysColumns.[Name] as ColumnName,   
    SysTypes.[Name] As DataType,   
    SysColumns.[Length] As Length   
FROM   
    SysObjects INNER JOIN SysColumns   
ON SysObjects.[Id] = SysColumns.[Id]   
    INNER JOIN SysTypes  
ON SysTypes.[xtype] = SysColumns.[xtype]  
WHERE  SysObjects.[type] = 'U'  

and SysColumns.[Name] like '%mytable%'

ORDER BY  SysObjects.[Name]