SQL Script to find the tables created from a given date

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