Database queries

Question

Hi friends Is there any query to get the list of database, sp and tables thanks in advance

Gaurish Kumar · Answer

Hi try this Sql Queries for getting the list of tables and Stored Procedure. For Tables: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES For Stored Procedure: Select [NAME] from sysobjects where type = 'P' and category = 0 For Views: Select [NAME] from sysobjects where type = 'V' and category = 0

Pankaj Rana · Answer

hi try this query to get list of tables created by user : Use Database_Name Select * from sysobjects where type='u'

Purushottam Rathore · Answer

Hi Sanjay follow this link to find stored procedure and tables from the database. http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=65048 To find all stored procedure of the database: select * from sys.objects where type='p' To find all tables of the database: select * from sys.objects where type='u' To find stored procedure and tables of the database: select * from sys.objects To find list of database: select name from master..sysdatabases

Sanjay Chauhan · Answer

Thanks friends, for your valuable answers.

Database queries

Answers (4)