display all table name and storedprocedures

Question

I have two database student and student1 i want to display all table name and storedprocedures extsts in student but not in student1

Jaganathan Bantheswaran · Answer

Hi Try this select * from information_schema.tables where table_type = 'base table' select * from sysobjects where type='p' the above query worked .

Krishna Garad · Answer

check out this select * from sysobjects where xtype='u' // for user defined tables select * from sysobjects where xtype='p'// for stored procedure select * from sysobjects where xtype='f''//for function select * from sysobjects where xtype='v'//for view