Skip to content
  • SQL-Server
  • Linux
  • PowerShell
  • Ispconfig
  • Avamar
  • General
  • Oracle
  • SAP Hana
Facebook LinkedIn
SCHELSTRAETE.ORG

I.T. minded

  • SQL-Server
  • Linux
  • PowerShell
  • Ispconfig
  • Avamar
  • General
  • Oracle
  • SAP Hana
SCHELSTRAETE.ORG

I.T. minded

T-SQL: Creation date/time of tables

  • BartBart
  • February 11, 2019
  • SQL-Server

When you are looking for the creation date/time of certain tables, you can easily find that in the sys.tables.
You can use the code below in order to list all tables, and the creation date of those tables.

SELECT [name] AS [TableName], [create_date] AS [CreatedDate] FROM sys.tables
Default image
Bart
Articles: 91
Previous Post T-SQL: Find the creation time of SQL accounts
Next Post T-SQL: Flush memory cache for testing purposes
No results

Recent Posts

  • Linux: create MO files from PO files (wp)
  • Linux: migrate storage with pvmove
  • Systemd: automatically restart after failure
  • Clamav: limit memory usage
  • Oracle: Map ASM disks to physical disks

Archives

  • January 2022
  • December 2021
  • October 2021
  • September 2021
  • July 2020
  • March 2020
  • February 2020
  • August 2019
  • July 2019
  • June 2019
  • May 2019
  • April 2019
  • February 2019
  • November 2017
  • August 2017
  • July 2017
  • June 2017
  • April 2017
  • March 2017
  • February 2017
  • January 2017
  • December 2016

Categories

  • Avamar
  • General
  • Ispconfig
  • Linux
  • Oracle
  • PowerShell
  • SAP Hana
  • SQL-Server
  • Uncategorized

Related Posts

T-SQL: Group timestamp by Year/Month

  • January 6, 2022

T-SQL: Add/drop pass to open a database master key

  • January 6, 2022

T-SQL: Jobs in suspended state

  • January 2, 2022

Copyright © 2022 Schelstraete.org