Tuesday, January 20, 2015

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.

        [name] as Tablename
        sys.tables where cast(create_date as date)>='Given date' 

No comments:

Post a Comment