How to find the date and time of last updated table?
Answer Posted / smitha
select name,create_date,modify_date from sys.tables
order by modify_date desc
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
How to create an inline table-valued function?
What is attribute? : sql server analysis services, ssas
What are the types of lock supported by ?
What is the contrast between sql and mysql?
How to see existing views in ms sql server?
What is difference between clustered index and non clustered index?
How to enter binary string literals in ms sql server?
How to search for a string in all stored procedure in sql server?
What is user defined datatypes and when you should go for them?
Difference between connected and disconnected database in .net with sql server?
what do you understand by change data capture?
Can select statements be used on views in ms sql server?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What do you mean by an execution plan?
How to loop through result set objects using mssql_fetch_array()?