Interested to Buy Any Domain ? << Click Here >> for more details...
How to find the date and time of last updated table?
- 6 Answers
- 9657 Views
- Teledata, I also Faced
- E-Mail Answers
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
Do you know what is sql injection?
Show Practically Sql Server Views are updatable?
How do you rebuild an identity column?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
How to delete duplicate records based on single column from a table?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
How can I tell if sql server is 32 or 64 bit?
Is t sql the same as sql server?
What are page splits? : SQL Server Architecture
Tell about MOM Tool(Microsoft Operator Manager)?
How many types of keys are there?
Define candidate key, alternate key, and composite key.
What is view in sql?
What is the difference between for xml raw and for xml auto?
