ITPub博客

首页 > 数据库 > SQL Server > SQL Server 2005:模拟Oracle的desc命令编写的describe,查询表的结构

SQL Server 2005:模拟Oracle的desc命令编写的describe,查询表的结构

原创 SQL Server 作者:lawzjf 时间:2007-08-22 11:04:29 0 删除 编辑

create proc [dbo].[describe]

@table_name Nvarchar(100)

as

select c.name as column_name,

case t.name

when 'numeric' then

t.name+'('+cast(c.precision as varchar(5))+','+cast(c.scale as varchar(5))+')'

when 'char' then

t.name+'('+cast(c.max_length as varchar(5))+')'

when 'varchar' then

t.name+'('+cast(c.max_length as varchar(5))+')'

when 'nvarchar' then

t.name+'('+cast(c.max_length as varchar(5))+')'

else t.name

end as type,

case c.is_nullable

when 1 then ' '

else 'NOT NULL'

end as nullable

from sys.all_columns as c, sys.types as t

where c.system_type_id=t.system_type_id

and t.name<>'sysname' and c.object_id=object_id(@table_name)

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/37724/viewspace-964935/,如需转载,请注明出处,否则将追究法律责任。

上一篇: MySQL数据字典
下一篇: MySQL中的show命令
请登录后发表评论 登录
全部评论

注册时间:2008-01-18

  • 博文量
    279
  • 访问量
    943844