Query all table names, field names, types, lengths, and stored procedures, and create statements for views

--Get Stored Procedure creation statement 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--get view path creation statement 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--queries all table names, field names, types, lengths 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--all the data comes from these four tables--select * from Sysobjects--select * from Syscolumns--select * from Syscomments--s Elect * from systypes

Query all table names, field names, types, lengths, and stored procedures, and create statements for views