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