Monday, 27 February 2023

SQL

 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

c#

 https://github.com/dcyuksel/Result