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’
Continue Reading