get newly created Tables LIst
select schema_name(schema_id) as schema_name,
name as table_name,
create_date,
modify_date
from sys.tables
where create_date > DATEADD(DAY, -30, CURRENT_TIMESTAMP)
order by create_date desc;
https://dataedo.com/kb/query/sql-server/find-recently-created-tables.
To know SP Names
select name,create_date,modify_date
from sys.procedures
order by modify_date desc
No comments:
Post a Comment