Question

in which table data is rearly modified
​

Answer 1

Answer:

Query

select schema_name(schema_id) as schema_name,

name as table_name,

create_date,

modify_date

from sys.tables

where modify_date > DATEADD(DAY, -30, CURRENT_TIMESTAMP)

order by modify_date desc;

Columns

schema_name - schema name

table_name - table name

create_date - table creation date

modify_date - last update time of table (by ALTER statement)

Rows

One row: represents one table in a schema

Scope of rows: all tables which was last modified in the last 30 days in all schemas

Ordered by: modify time descending

Explanation:

HOPE MY ANSWER HELPS

please follow me and like my all answers and please mark me as brainlist