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’
Share this:
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
… [Trackback]
[…] Here you can find 77926 more Info on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Read More Information here to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Read More Information here to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More on to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Read More on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More Information here to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] There you will find 92944 more Information on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More on to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Read More on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Here you will find 98081 additional Info on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More Information here to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Info to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Information on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More on to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Read More on on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Info on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Information on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] There you can find 89342 additional Info on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More on on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Read More to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Information to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More Information here on that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]
… [Trackback]
[…] Find More on to that Topic: techmixing.com/2015/01/sql-script-to-find-tables-created-fro.html […]