Sql

Search

sql list all procedures

SELECT
	"routine_type",
	"specific_catalog",
	"routine_name",
	"routine_definition"
  FROM db_name.INFORMATION_SCHEMA.ROUTINES
 WHERE ROUTINE_TYPE = 'PROCEDURE'

Comment

sql list all procedures

SELECT
	"routine_type",
	"specific_catalog",
	"routine_name",
	"routine_definition"
  FROM db_name.INFORMATION_SCHEMA.ROUTINES
 WHERE ROUTINE_TYPE = 'PROCEDURE'

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql workbench in ubuntu 14.04
Sql :: last 24 HOUR data in mysql
Sql :: select duplicates in sql
Sql :: mysql dump all databases
Sql :: mariadb select multiple rows into one column
Sql :: too many connections mysql
Sql :: get all tables postgres
Sql :: force drop all tables postgres
Sql :: how to check port number for postgresql
Sql :: check current sequence value postgres
Sql :: mysql add boolean column
Sql :: pdo mysql insert
Sql :: get schema of table sql
Sql :: Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
Sql :: oracle search text in all packages
Sql :: import sql mysql ubuntu
Sql :: change column name mysql command line
Sql :: no data found oracle
Sql :: Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Sql :: oracle sql first day of month
Sql :: name of today sql
Sql :: ora-01950 no privileges on tablespace
Sql :: list all permissions on a table in postgres
Sql :: oracle drop chain step
Sql :: mysql password error create datbase
Sql :: how to check database username and password in postgresql
Sql :: oracle alert log location
Sql :: left join with only first record
Sql :: foreign key oracle
Sql :: mysql find foreign key references

Search

SQL

sql list all procedures

sql list all procedures

ADD CONTENT