Posted By

indra on 08/24/10


Tagged

sqlserver


Versions (?)

Show User Table-Func-Sp


 / Published in: SQL
 

  1. --List Tables
  2. SELECT * FROM IATA30R..sysobjects WHERE xtype = 'U'
  3.  
  4. --List Stored Procedure
  5. SELECT * FROM IATA30R..sysobjects WHERE xtype = 'P' AND [name] LIKE 'sp%'
  6.  
  7. --List Functions
  8. SELECT * FROM IATA30R..sysobjects WHERE xtype = 'FN'

Report this snippet  

You need to login to post a comment.