Advanced Search

Show User Table-Func-Sp

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

Expand | Embed | Plain Text

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

You need to login to view comments.