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
MsSql获得指定表的 表结构脚本
最新推荐文章于 2021-04-19 11:10:58 发布