Tip: Hledat pouze výsledky v angličtině. Jazyk vyhledávání můžete nastavit na stránce Nastavení.
3. 3. 2023 · Learn how to view a list of databases on an instance of SQL Server by using SQL Server Management Studio or Transact-SQL.
Lidé se také ptají
How do I list all databases in SQL?
How do I get a list of SQL Servers?
How do I show database names in mssql?
How to get a list of all tables in SQL database?
29. 9. 2008 · To list all available databases in MS-SQL Server using T-SQL, you can execute the following query: SELECT name, database_id, create_date ...
3. 3. 2023 · This article describes how to view a list of databases on an instance of SQL Server by using SQL Server Management Studio or Transact-SQL.
17. 6. 2024 · To get a list of all databases on the SQL Server, use the query: SELECT * FROM sys.databases;. This command can also be modified to only look at ...
SHOW databases using SQL Command ; SELECT * FROM sys.databases; ; SELECT name, database_id, create_date FROM sys.databases; ; EXEC sp_databases;.
To view a list of databases on an instance of SQL Server · Connect to the [!INCLUDEssDE]. · From the Standard bar, select New Query. · Copy and paste the following ...
Enhance your database querying skills and learn methods to list tables in SQL Server, suitable for both older and newer versions.
9. 3. 2021 · To view a list of databases in SQL Server, you can either query a table or run a stored procedure. You can run this query: SELECT name FROM sys.
21. 5. 2024 · Listing all databases in SQL Server is a common task for database administrators and developers. SQL Server provides two main methods to solve ...
Get Detailed SQL Server Database File Location Information in a Few Clicks ; SQL Server 2017 —C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\ ...