Introduction:
Here I will explain simple SQL
Query to get list of all stored procedures from SQL
Server database or How to get list of all stored procedures in SQL
Server Database or How to Get list of all tables in SQL
Server database.
Description:
In previous articles I explained Pass table as parameter to stored procedure in SQL Server, Different types of joins in SQL Server, Difference between len & datalength functions in SQL Server,
convert rows to columns in sql server without using pivot, Create database schema diagrams in SQL Server, Delete Duplicate records from 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 Stored procedure names 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
|
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
|
|
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
|
|||
5 comments :
properties of table
hi ahmad , below query will show you properties of table,maybe its correct or not just chech it out..
"exec sp_columns Table Name"
Hi Sir....
what is meant by the following if condition in mysql workbench storedprocedure?what output it will return?
(here, para_disability_id is the parameter am passing and candidates.disability_id is the value i taken from table)
if(para_disability_id=-1,0=0,cand.disability_id=para_disability_id)
USE SampleDB
SELECT * FROM SYS.PROCEDURES
gives incorrect result. i have 10 database in SQL Sever. It is not giving correct result.
it's working.........
Note: Only a member of this blog may post a comment.