create procedure dbo.[schema_update]
    @dbname varchar(50)
as
begin
    declare @sql nvarchar(255);
    set @sql = 'select * from ' + @dbname + '.INFORMATION_SCHEMA.COLUMNS';
    EXECUTE (@sql)
end
go

Hope this helps...