Search
 
SCRIPT & CODE EXAMPLE
 

SQL

show databases in sql server

SELECT * FROM SYS.DATABASES
Comment

show databases in sql server

SELECT * FROM SYS.SYSDATABASES
Comment

show databases in sql server

EXEC sp_databases
Comment

show databases in sql server

SELECT name FROM master.SYS.DATABASES
Comment

How to show list of databases in a connection

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| django_mysql_one   |
| django_mysql_two   |
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
6 rows in set (0.71 sec)
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql default timestamp value to be current timestamp 
Sql :: oracle enable job 
Sql :: mysql get column names from table 
Sql :: postgresql db owner change 
Sql :: neo4j display all nodes and relationships 
Sql :: show databases in sql server 
Sql :: UseSqlServer no definition 
Sql :: how to increase size of column in sql 
Sql :: to date oracle with time 
Sql :: while loop sql 
Sql :: sql first day of current year 
Sql :: sql_mode=only_full_group_by 
Sql :: sql server last executed query 
Sql :: sql several or 
Sql :: alter table delete column 
Sql :: group_concat length limit 
Sql :: sql skip the first row 
Sql :: how to run mysql in git bash 
Sql :: how to remove unique key constraint in mysql 
Sql :: sqlite connection string 
Sql :: sql server check port number 
Sql :: install mysqldump ubuntu 
Sql :: stop psql server windows 
Sql :: set sequence value oracle 
Sql :: get current year sql 
Sql :: sql server convert date to int 
Sql :: psql autocomplete for mac brew install 
Sql :: pop sql insert value into 
Sql :: host is not allow to connect to this mysql server 
Sql :: apex select list ORA-20999 
ADD CONTENT
Topic
Content
Source link
Name
3+6 =