Get list of databases from SQL Server
Posted By: sef
How can I get the list of available databases on a SQL Server instance? I’m planning to make a list of them in a combo box in VB.NET.
Solution
Execute:
SELECT name FROM master.sys.databases
This the preferred approach now, rather than dbo.sysdatabases, which has been deprecated for some time.
Execute this query:
SELECT name FROM master.dbo.sysdatabases
or if you prefer
EXEC sp_databases
Answered By: Ben Hoffstein
Related Articles
- What's the difference between eval, exec, and compile?
- An Authentication object was not found in the…
- Execution failed for task…
- SQL Server: Query fast, but slow from procedure
- Generate SQL Create Scripts for existing tables with Query
- Android- Error:Execution failed for task…
- How to find column names for all tables in all…
- Set value to vaadin combobox(polymer)
- vaadin-combo-box / vaadin-combo-box-overlay change…
- SQL query return data from multiple tables
- How to call Stored Procedure in a View?
- How do I obtain a Query Execution Plan in SQL Server?
- How can I get column names from a table in SQL Server?
- How can I require at least one checkbox be checked…
- Polymer, vaadin-combo-box; Get value of input
- What are the uses of the exec command in shell scripts?
- SQL Server query to find all permissions/access for…
- How to create a temporary table in SSIS control flow…
- What do 'real', 'user' and 'sys' mean in the output…
- Vaadin combobox value-changed not working
- python 3.2 UnicodeEncodeError: 'charmap' codec can't…
- Drop all the tables, stored procedures, triggers,…
- Select SQL Server database size
- How to manage nested arrays in Vuex Store and pass…
- sys.argv[1] meaning in script
- CSS Input with width: 100% goes outside parent's bound
- Why does find -exec mv {} ./target/ + not work?
- Maximum value for long integer
- Gradle: Execution failed for task ':processDebugManifest'
- python and sys.argv
- How to override style of vaadin element?
- Start redis-server with config file
- T-SQL: Export to new Excel file
- How to find all serial devices (ttyS, ttyUSB, ..) on…
- How do I find the data directory for a SQL Server instance?
- How do I check what version of Python is running my script?
- Error:Execution failed for task…
- How to create a drop shadow only on one side of an element?
- Mean per group in a data.frame
- PHP - count specific array values
- Procedure or function !!! has too many arguments specified
- Determine if Python is running inside virtualenv
- SQL Server, How to set auto increment after creating…
- T-SQL How to create tables dynamically in stored procedures?
- SSH Private Key Permissions using Git GUI or…
- How should I deal with "package 'xxx' is not…
- Python sys.argv lists and indexes
- SQL Server stored procedure Nullable parameter
- How to run python script with elevated privilege on windows
- Ember 2, filter relationship models (hasMany,…
- Differences between fork and exec
- How do I get the path of the current executed file…
- Add unique constraint to combination of two columns
- Listing information about all database files in SQL Server
- Create a view with ORDER BY clause
- How to convert java.util.Date to java.sql.Date?
- Why is Ember throwing "Uncaught Error: Assertion…
- python: sys is not defined
- Angular 2 Polymer Vaadin combo-box set value programatically
- Manually raising (throwing) an exception in Python
- List of all index & index columns in SQL Server DB
- Text size and different android screen sizes
- Why use sys.path.append(path) instead of…
- How to find out what is locking my tables?
- How to obtain the start time and end time of a day?
- How do you clone/copy a DOM node's shadow Dom?
- Database development mistakes made by application developers
- How can I drop a table if there is a foreign key…
- Subquery returned more than 1 value.This is not…
- How to query for Xml values and attributes from…
- rerender Backbone views without losing references to dom
- How to rollback or commit a transaction in SQL Server
- How to display default text "--Select Team --" in…
- Problem reaching Contentful's API with getEntry()…
- How do I detect the Python version at runtime?
- How do I determine if my python shell is executing…
- How to dynamically add and remove views with Ember.js
- How do I execute a MS SQL Server stored procedure in…
- What's the difference between Instant and LocalDateTime?
- Update Query with INNER JOIN between tables in 2…
- How do I execute a program using Maven?
- How to get the list of all database users
- Foreign Key to multiple tables
- How to pass an array into a SQL Server stored procedure
- adding directory to sys.path /PYTHONPATH
- Are PDO prepared statements sufficient to prevent…
- Exception : AAPT2 error: check logs for details
- Permanently adding a file path to sys.path in Python
- The difference between fork(), vfork(), exec() and clone()
- Check for file exists or not in sql server?
- Expand Python Search Path to Other Source
- SecurityException: Permission denied (missing…
- List of Timezone IDs for use with FindTimeZoneById() in C#?
- Maximum and Minimum values for ints
- How to make Python script run as service?
- Use SQL Server Management Studio to connect remotely…
- Passport.js in Next.js app not saving user across…
- Adding an identity to an existing column
- How do I set a VB.Net ComboBox default value
- SQL Server SELECT into existing table
Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.
