Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

How to find the date and time of last updated table?

Question Posted / hari

Answers were Sorted based on User's Feedback



How to find the date and time of last updated table? ..

Answer / payal nath

We can determine the last time a user table was altered
using the below query.

SELECT name, create_date, modify_date
FROM sys.tables
ORDER BY modify_date DESC

The modify_date column is updated whenever a column is
added or altered for the table.
It is also updated if the clustered index is changed.

Is This Answer Correct ?    21 Yes 15 No

How to find the date and time of last updated table? ..

Answer / kavitha

getdate() doesnt work for the above query

Is This Answer Correct ?    1 Yes 0 No

How to find the date and time of last updated table? ..

Answer / ramendra kumar

TO FIND THE NEW DATE ABOUT LAST RECENT CONFIGURE TABLE
SYNTEX WE BRING IN USE TO SEE THE DATE IS
GETDATE()

Is This Answer Correct ?    4 Yes 13 No

Post New Answer

More SQL Server Interview Questions

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

0 Answers   HCL,

What are the properties of the transaction?

0 Answers  

What are constraints? Explain different types of constraints?

26 Answers   Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,

CREATE a table from another table

2 Answers  

What is the difference between dbcc indexdefrag and dbcc reindex?

0 Answers  

How to retrieve error messages using mssql_get_last_message()?

0 Answers  

What is dbcc? Give few examples.

0 Answers  

Why do we need different type of parameter?

0 Answers  

Can foreign key be duplicate?

0 Answers  

How adventureworkslt tables are related?

0 Answers  

explain the storage models of olap? : Sql server database administration

0 Answers  

what is replication? where do u use Go Keyword?

1 Answers   Satyam,

For more SQL Server Interview Questions Click Here
Categories