tables created

Question

Post reply

tables created

Krasavita

SSC-Insane

Points: 23138
More actions
December 15, 2009 at 8:30 am

#385948

Is anyway to find out when all of my tables were created. Thank you

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

NickDBA Hall of Fame Points: 3799 More actions · Answer 1

Try something like this and check for createddate

select * from sys.objects where type = 'U'

*Thats create_date, not createddate

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 2

Or: select * sys.tables

Have you even bothered to read ANYTHING in Books Online? Do you even know what it is? Many of your questions could easily be answered by some simple research there by you.

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 3

I am with Lynn on this, read Books Online and search Google with the phrases you post here, you must be finding plenty of blogs, articles and such forum discussion on those topics, read few of them you must be getting an answer in one of them.

I don't discourage to post your questions at all, post them when you really are running short of any resources.

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

SQLRNNR SSC Guru Points: 281334 More actions · Answer 4

example google query:

sql server tables created date

yields the following result:

http://stackoverflow.com/questions/1171019/sql-server-table-creation-date-query

Then a good use of that result would be to try the script. If you are having difficulties with that - then you post your question about it here.

What Lynn and Bru are saying is that you seem to be posting questions without having made any effort beforehand other than to open SSC and post a new topic. Usually people are much more willing to help if you have shown that you have tried something.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Bru Medishetty SSC-Insane Points: 23606 More actions · Answer 5

CirquedeSQLeil (12/15/2009)
Usually people are much more willing to help if you have shown that you have tried something.

Absolutely right !

Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.comLearnSQLWithBru

Twitter -- BruMedishetty

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 6

Bru Medishetty (12/15/2009)
CirquedeSQLeil (12/15/2009)
Usually people are much more willing to help if you have shown that you have tried something.
Absolutely right !

Spot On!!