In this article, we will see how to find all the databases and their creation date in SQL Server.
We can list all database using
1. GUI method
2. SQL Statement
Find all the databases and their creation date in SQL Server using GUI mode.
1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.
2. To see a list of all databases on the instance, expand Databases.
3. To find the created date right click on database select properties.
Find all the databases and their creation date in SQL Server using SQL Statement
Execute the following query, it lists all databases names, id and its created date.
SELECT name, database_id, create_date FROM sys.databases ; GO