SQL Script to find the tables created from a given date

Posted on January 20, 2015 by vivekjohari
Below is the SQL query which can be used to find out the tables which are created or modified on or from a given date.

SELECT
        [name] as Tablename
       ,create_date
       ,modify_date
FROM
        sys.tables where cast(create_date as date)>=’Given date’ 

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in DBA, SQL Advanced, SQL Server and tagged , . Bookmark the permalink.

29 Responses to SQL Script to find the tables created from a given date

  1. Pingback: Great Child Toys

  2. Pingback: filler

  3. Pingback: บาคาร่า

  4. Pingback: ศัลยกรรมเกาหลี

  5. Pingback: fantasy warrior art

  6. Pingback: How to watch Rugby World Cup 2019 live stream online instantly

  7. Pingback: คาสิโน

  8. Pingback: แทงบอลออนไลน์

  9. Pingback: vegus

  10. Pingback: 온라인카지노

  11. Pingback: Nightmare Market Exit Scam

  12. Pingback: Wine Boongie Boongy Junkanoo Rake N Scrape

  13. Pingback: Website

  14. Pingback: Dream Market

  15. Pingback: ebenin amini türkce izle

  16. Pingback: rubiks.glove.co.il

  17. Pingback: ซี ฉัตรปวีณ์ ตรีชัชวาลวงศ์

  18. Pingback: dentist Kissimmee/Orlando

  19. Pingback: pelangiqq

  20. Pingback: jaguar qq

  21. Pingback: kompasqqq

  22. Pingback: w88 casino online

  23. Pingback: Estate Agents in Brighton

  24. Pingback: senang poker

  25. Pingback: paragnost

  26. Pingback: daftar qiuqiu99

  27. Pingback: cbdadverts.com

  28. Pingback: duratrans printing

  29. Pingback: buy vape carts online

Leave a Reply