SQL SERVER导出所有表及表字段

23rew

/*
Goal：MS SQL SERVER：Output all the field and its’ table
author:AllisonHuang
created date :20140613
*/
--select [id], [name] from [sysobjects] where [type] = 'u' order by [name]
drop table  #temping
create table #temping (id varchar(200),name varchar(200),namedetail varchar(200))
--SELECT name,id FROM SysColumns WHERE id=Object_Id('ABUSEDSTOCK')
declare @id varchar(20)
declare @name varchar(20)

declare cursor1 cursor for         --定义游标cursor1
select [id], [name] from [sysobjects] where [type] = 'u' order by [name]
open cursor1                       --打开游标
fetch next from cursor1 into @id,@Name --将游标向下移行，获取的数据放入之前定义的变量@id,@NUM中
while @@fetch_status=0           --判断是否成功获取数据
begin
insert into  #temping
SELECT id,@name,name FROM SysColumns WHERE id=Object_Id(@Name)
--id is Object_Id(@Name)'s id ,not [sysobjects]'s.
fetch next from cursor1 into @id,@Name  --将游标向下移行
end
close cursor1                   --关闭游标
deallocate cursor1
select * from #temping