• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 51
  • Last Modified:

SQL - When a table was created and by who

Dear Experts,

Could you please advise about the SQL code which would list the tables with their creation date and creator?

Actually having the following code which lists the creation and modification date, but did not find the creator

SELECT
	name,
	object_id,
	create_date,
	modify_date
FROM
	sys.tables

Open in new window


Thanks in advance,
1
csehz
Asked:
csehz
1 Solution
 
Pawan KumarDatabase ExpertCommented:
0
 
csehzIT consultantAuthor Commented:
Thank you for the clarification
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now