Tag Archives: db creation date

How to: Identify Database Creation Date

Sometimes the database creation date will help you to examine whether any database within your SQL Server environment has been dropped and recreated or identify when the new database created. The following T-SQL statement will provide you a simple piece of information on that.

SELECT 
	name AS [DB Name], 
	dbid AS [DB ID]
	crdate AS [Created Date]
FROM 
	master..sysdatabases

Meanwhile, you might probably want to check out how to examine your table creation date and last modified date in order to help you dive deeper into your SQL Server environment.