Skip to content
  • Home
  • SteamDeck
  • Linux
  • SQL-Server
  • PowerShell
  • Oracle
Schelstraete.orgSchelstraete.org
SCHELSTRAETE.ORG

I.T. minded

  • Home
  • SteamDeck
  • Linux
  • SQL-Server
  • PowerShell
  • Oracle
LinkedIn Email
Schelstraete.orgSchelstraete.org
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
Share your love
Bart
Bart
Articles: 100
T-SQL-Commands
Previous Post T-SQL: Find the creation time of SQL accounts
Next Post T-SQL: Flush memory cache for testing purposes
T-SQL-Commands
No results

Recent Posts

  • Steam Deck: Hogwarts Legacy performance
  • T-SQL: Check cpu usage SQL statements
  • Steam Deck: Transfer files from Windows to Deck
  • PowerShell: Check TLS version
  • T-SQL: Identify queries that consume a large amount of log space

Archives

  • February 2023
  • December 2022
  • 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
  • SteamDeck
  • Uncategorized
Related Articles
T-SQL-Commands

T-SQL: Check cpu usage SQL statements

  • Bart
  • February 17, 2023
T-SQL-Commands

T-SQL: Identify queries that consume a large amount of log space

  • Bart
  • February 14, 2023
T-SQL-Commands

T-SQL: Shrink incremental

  • Bart
  • December 28, 2022

Copyright © 2023 Schelstraete.org

Add Schelstraete.org as app.

ADD