SQL queries all table names, field names, types, lengths, stored procedures, views

--get the stored procedure creation statementSelecto.xtype,o.name,cm.text  fromsyscomments cmInner Joinsysobjects o onO.id=cm.idwhereXtype='P'Order  byo.xtype,o.name,cm.text   --Get view path creation statementSelecto.xtype,o.name,cm.text  fromsyscomments cmInner Joinsysobjects o onO.id=cm.idwhereXtype='v'Order  byo.xtype,o.name,cm.text   --query all table names, field names, types, lengthsSelectO.name, C.name,t.name,c.length fromsyscolumns CInner JoinSystypes T onC.xtype=T.xtypeInner Joinsysobjects o onC.id=o.idwhereO.xtype='u'Order  byO.name, C.name,t.name--all the data comes from these four sheets .--select * from sysobjects--SELECT * from syscolumns--SELECT * from syscomments--SELECT * from systypes

SQL queries all table names, field names, types, lengths, stored procedures, views