oracle查询表信息快捷键,在查询分析器中，用快捷键取得字段的列表。-数据库专栏,SQL Server...

alter      procedure sp_getfields

@tablename varchar(100)

as

declare tmpcursor cursor for

select name from syscolumns where id = object_id(@tablename)

open tmpcursor

declare @fieldname varchar(50)

declare @sqlstr1 varchar(250)

declare @sqlstr2 varchar(250)

set @fieldname =

set @sqlstr1 =

set @sqlstr2 =

fetch next from tmpcursor into @fieldname

while @@fetch_status = 0

begin

if len(@sqlstr1) < 250 – len(@fieldname)

set @sqlstr1 = @sqlstr1 + @fieldname + ,

else

set @sqlstr2 = @sqlstr2 + @fieldname + ,

fetch next from tmpcursor into @fieldname

end

close tmpcursor

deallocate tmpcursor

if @sqlstr2 =

set @sqlstr1 = left(@sqlstr1, len(@sqlstr1) -1)

else

set @sqlstr2 = left(@sqlstr2, len(@sqlstr2) -1)

select @sqlstr1

if @sqlstr2 <>

select @sqlstr2

加了快捷键后，在查询分析器中，选中一个表名，按相应的快捷键，酷吧。