Introduction:
Here I will explain simple SQL
Query to get all table, procedure names in database or How to get list of all
tables names in SQL
Server Database or How to Get list of all procedures in SQL
Server database.
Description:
In previous articles I explained Create database schema diagrams in SQL Server, Delete Duplicate records from SQL Server, Exception handling in SQL Server stored procedure, Reading xml file using SQL Server and many articles
relating to SQL Server. Now I will explain how to get all tables and
stored procedures in database using SQL
Server.
Get
List of table names in database
To get list of tables in SQL
Server we need to write the query like as shown below
USE SampleDB
SELECT * FROM
SYS.TABLES
|
Get
List of Stored Procedures in database
To get list of procedures in SQL
Server we need to write the query like as shown below
USE SampleDB
SELECT * FROM
SYS.PROCEDURES
|
|
If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email. |
|||
Subscribe by RSS
Subscribe by Email
|
|||
3 comments :
This is abhinavsingh993 ,simply great and innovative now please sir would you guide me to know how to do CRUD operations using .xsd(dataset) files.
sir i need help of installing sql and working on sql please help me i am doing MCA final year
iHi Sir, in my sql i want to know this meaning if(a=-1,0=0,a=b) please can u answer ...
Note: Only a member of this blog may post a comment.