<div id="navBarDiv" runat="server" style="padding: 3px; margin:5px 0px 0px 0px; background: #144282; height: 40px; width: 100%; text-align: left;border:0px solid transparent">

SELECT table_name=sysobjects.name,
         column_name=syscolumns.name,
         datatype=systypes.name,
         length=syscolumns.length
    FROM sysobjects 
    JOIN syscolumns ON sysobjects.id = syscolumns.id
    JOIN systypes ON syscolumns.xtype=systypes.xtype
   WHERE sysobjects.xtype='U'
ORDER BY sysobjects.name,syscolumns.colid