583e507f   
   From: esquel@sommarskog.se   
      
   björn lundin (b.f.lundin@gmail.com) writes:   
   > In other databases, the prompt-tool offers a way of doing dml/ddl   
   > statements.   
   > They usually have a way of describing objects in the db as well   
   > I have not found that with sqlcmd yet.   
      
   Try "EXEC sp_help 'tbl'". Which you can shorten to "sp_help tbl", as long   
   as there is no schema component in the name.   
      
   Although, Microsoft is moving away from the sp_helpxxx procedures, why new   
   features may not be presented in these. Rather, MS thinks it better to query   
   the catalog views directly.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)