SQL Script to find the tables created from a given date

DBA SQL Advanced SQL Server
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’ 

1 thought on “SQL Script to find the tables created from a given date

  1. Pingback: Great Child Toys

Leave a Reply