MsSql获得指定表的 表结构脚本

if exists (select * from sysobjects where  objectproperty(object_id('up_getTableStruct'), 'IsProcedure') = 1)
drop procedure up_getTableStruct
go
create procedure up_getTableStruct 
@tablename sysname 
as 
begin
set nocount on
declare @i_objectId int, -- 对象id 
@i_indId smallint, -- 索引id 
@v_pkInfo varchar(100), -- 主键信息 
@v_clusteredInfo varchar(20), -- clustered信息 
@v_pkCol varchar(100), -- 主键字段 
@v_key varchar(50), 
@i_i smallint 
create table #temp1 
( 
i_id int identity, 
v_desc varchar(200) 
) 
declare @v_tableName varchar(256)
declare getTableStruct_cur cursor for select name from sysobjects where name = @tableName --改条件为 type='U' 则是获取的所有表
open getTableStruct_cur
fetch next from getTableStruct_cur into @v_tableName
while @@fetch_status=0
begin

set @i_objectId = object_id(@v_tableName) 

insert into #temp1(v_desc) 
va