你的位置:首页 > 数据库

[数据库]SQL 查询所有表名、字段名、类型、长度、存储过程、视图


-- 获得存储过程创建语句select o.xtype,o.name,cm.text from syscomments cm inner join sysobjects o on o.id=cm.id where xtype ='p'order by o.xtype,o.name,cm.text  -- 获得视图程创建语句select o.xtype,o.name,cm.text from syscomments cm inner join sysobjects o on o.id=cm.id where xtype ='v'order by o.xtype,o.name,cm.text  -- 查询所有表名、字段名、类型、长度select o.name, c.name,t.name,c.length from syscolumns cinner join systypes t on c.xtype= t.xtypeinner join sysobjects o on c.id= o.idwhere  o.xtype='u'order by o.name, c.name,t.name -- 所有数据都来自于这四张表--select * from sysobjects --select * from syscolumns--select * from syscomments--select * from systypes