[IWE] requesting help with T-SQL on Sysobjects table

golf_lover44 iwe@warhead.org.uk
Tue, 9 Jan 2007 15:12:23 -0800 (PST)


Here is the T-SQL code that I want to perform:

declare	@B	int
if exists (select @B = uid
	from sysobjects
		where name = 'temprbsa33' and
			type = 'U')
begin
	case
		when @B = 10 then drop table sabreguest.temprbsa33
		when @B = 1  then drop table temprbsa33
	end
end

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com