• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

How to read "Created Date" table property?

Using a T-SQL query, how do I retrieve the "Created Date" general property of the table?  (In other words the date/time the table was created).  I don't see that querying INFORMATION_SCHEMA will provide this.

Thanks!
0
pragmatistMS
Asked:
pragmatistMS
1 Solution
 
chapmandewCommented:
select create_date from sys.tables
where name = 'tablename'
0
 
pragmatistMSAuthor Commented:
thanks!
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now