Show User Table-Func-Sp


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.