Advanced Search

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