PROCEDURE  spSkyServerColumns

Return the list of Columns in a given table


Returned table has the format:
  • Name -- name of column
  • Type -- datatype (see SQL Server Books online)
  • Nullable -- flag 'yes' or 'no'
  • Length -- lenght of field
  • Decription -- from the online documentation.
    sample:
    exec spSkyServerColumns 'PhotoObj', 'dbo' Used by the QA interface.
  • Input and output parameters

    nametypelengthinoutpnum
    @TableNamevarchar400input1
    @OwnerNamevarchar400input2