Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 3 Answers
- 9266 Views
- I also Faced
- E-Mail Answers
Answer Posted / manoj
select table_name from user_tables where last_analyzed in
(select max(last_analyzed) from user_tables)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to trouble shoot if unable to connect SQL Server
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What is the difference between TRUNCATE and DROP?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is the maximum number of index per table?
What is history table in sql server?
What is executereader?
What are the extra roles available in msdb? : sql server security
Relational calculus is what type of language?
How do I view views in sql server?
What is the sql case statement used for?
What are page splits?
How to enable/disable indexes?
How to query multiple tables jointly?
Can I disable or restrict ssrs export formats (rendering formats)?
