Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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 
ADD CONTENT
Topic
Content
Source link
Name
6+2 =