JHU Mirror

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

name type length inout pnum

@TableName varchar 400 input 1

@OwnerName varchar 400 input 2

name	type	length	inout	pnum
@TableName	varchar	400	input	1
@OwnerName	varchar	400	input	2