LISTING 2: SQL Server 7.0 Version of Stored Procedure to Generate a Table Structure View

CREATE PROCEDURE sp_desc

@tablename varchar(50)=Null
AS

select  cast(syscolumns.name as varchar(15)) name,
convert(varchar(15),systypes.name) type,syscolumns.length,
"NULLS?"=  case when syscolumns.isnullable = 0 then
       'No'
     else
       'Yes'
     end
from syscolumns inner join sysobjects on syscolumns.id = sysobjects.id
left outer join systypes on syscolumns.usertype = systypes.usertype
where sysobjects.name=@tablename

return(0)