How to Get table create and last modify date time using PL-SQL in SQL server 2008?

Question

how to check if table exist and if it doesnt exist create table in sql server 2008

Answer 1

In sql server 2008 we can check created and modified date time of table using simple query in PL-SQL

Query:

Select name as 'Table Name', create_date as 'Creation Date', modify_dateas 'Modification Date' from sys.objects

where type_desc= 'USER_TABLE'

Results:

Table Name    Creation Date                                                Modification Date

Login       2008-09-18 12:38:47.840             2008-09-18 12:38:47.843

Users       2008-09-18 12:38:47.840             2008-09-18 12:38:47.843

Settings    2008-09-18 12:38:47.840             2008-09-18 12:38:47.843

Roles       2008-09-18 12:38:47.840             2008-09-18 12:38:47.843

Customers   2008-09-18 12:38:47.840             2008-09-18 12:38:47.847

Using this functionality we can easily get creation and modification date of table created by any user in any database.