Return to Snippet

Revision: 30868
at August 24, 2010 14:11 by indra


Initial Code
--List Tables
SELECT * FROM IATA30R..sysobjects where xtype = 'U'

--List Stored Procedure
SELECT * FROM IATA30R..sysobjects WHERE xtype = 'P' and [name] like 'sp%'

--List Functions
SELECT * FROM IATA30R..sysobjects where xtype = 'FN'

Initial URL


Initial Description


Initial Title
Show User Table-Func-Sp

Initial Tags


Initial Language
SQL