Document SQL Server 2000/2005 Database

else if @SqlVersion = '2005' <br />
	begin<br />
	insert into #Columns  (Name, Type, Nullable, [description],refName, refObj, refCol, refOnerTable )<br />
	--FOR 2005	<br />
Select c.name, <br />
	type_name(user_type_id) + (<br />
	case when (type_name(user_type_id) = 'varchar' or type_name(user_type_id) = 'nvarchar' or type_name(user_type_id) ='char' or type_name(user_type_id) ='nchar')<br />
		then '(' + cast(max_length as varchar) + ')' <br />
	 when type_name(user_type_id) = 'decimal'  <br />
			then '(' + cast([precision] as varchar) + ',' + cast(scale as varchar)   + ')' <br />
	else ''<br />
	end				<br />
	), <br />
	case when is_nullable = 1 then 'Y' else 'N'  end,<br />
	cast(p.value as varchar(4000)),<br />
	f.name, <br />
	object_name(fc.referenced_object_id) , <br />
	COL_NAME (fc.referenced_object_id, fc.referenced_column_id) ,<br />
	'[' +fs.name + '].[' + fo.name + ']' <br />
from sys.columns c<br />
	inner join #Tables t on t.object_id = c.object_id<br />
	left outer join sys.extended_properties p on p.major_id = c.object_id and p.minor_id  = c.column_id and p.name = 'MS_Description' <br />
	left outer join sys.foreign_key_columns  fc  on t.object_id = fc.parent_object_id <br />
												AND c.column_id = fc.parent_column_id<br />
	left outer join sys.foreign_keys f on t.object_id = f.parent_object_id<br />
										and f.object_id = fc.constraint_object_id <br />
	left outer join sys.objects fo on fo.object_id = f.referenced_object_id<br />
	left outer join sys.schemas fs on fs.schema_id = fo.schema_id <br />
where t.id = @i<br />
order by c.column_id

select @Output =<br />
			case WHEN refObj is null then<br />
				 '<tr><td width="20px" align="center">' + Cast((@j) as varchar) + '</td><td width="150px">' + isnull(name,'')  + '</td><td width="150px">' +  upper(isnull(Type,'')) + '</td><td width="50px" align="center">' + isnull(Nullable,'N') + '</td><td>' + isnull([description],'') + '</td></tr>' <br />
				else '<tr><td width="20px" align="center">' + Cast((@j) as varchar) + '</td><td width="150px" title="'+isnull(refName, '')+'"><a href="#Table:' + isnull(refOnerTable,'') + '">' +  isnull(name,'') + '</a></td><td width="150px">' +  upper(isnull(Type,'')) + '</td><td width="50px" align="center">' + isnull(Nullable,'N') + '</td><td>' + isnull([description],'') + '</td></tr>' <br />
			end<br />
			from #Columns  where id = @j