USE Northwind
SELECT name, modify_date FROM Sys.Tables
Where object_id IN
(SELECT object_id FROM sys.tables)
AND type = 'U'
OUTPUT:
TableName ModifyDate
Categories 2009-01-23 14:16:14.900
Customers 2009-01-23 14:16:15.103
Shippers 2009-01-23 14:16:14.790
Suppliers 2009-01-23 14:16:14.900
Orders 2009-01-23 14:16:14.790
Products 2009-01-23 14:16:14.900
Order Details 2009-01-23 14:16:13.653
CustomerCustomerDemo2009-01-23 14:16:15.107
CustomerDemographics2009-01-23 14:16:15.103
Region 2009-01-23 14:16:15.157
Territories 2009-01-23 14:16:15.180
EmployeeTerritories 2009-01-23 14:16:15.190
CustomersTemp 2009-02-20 17:37:34.083
Employees 2009-01-23 14:16:15.180
No comments:
Post a Comment