到处数据库表脚本

create function dbo.fn_tabScript(@tab varchar(50))returns varchar(6000)asbegin declare @r varchar(6000) select @r='create table ['+@tab+'] ('  select @r=@r+'['+b.name+'] '+c.name+case when c.name in('char','varchar','nchar','nvarchar') then '('+rtrim(b.max_length)+')' else '' end + case when b.is_nullable=0 then ' not null,' else ',' end  from sys.tables a inner join sys.columns b on a.object_id=b.object_id inner join sys.types c on b.system_type_id=c.system_type_id where a.name=@tab order by b.column_id  select @r=@r+')'  return @rend -- 调用方法select dbo.fn_tabScript('[表名]')