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’
Discover more from Technology with Vivek Johari
Subscribe to get the latest posts sent to your email.
