<div>
I have moved this question to MSSQL as it was in wrong TA.
</div>


I have moved this question to MSSQL as it was in wrong TA.

<div>
I can use this syntax to retrive all the size of the table. Can I also retrive the datecreated of the table ?<br />
<br />
EXEC &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;sp_msforeachtable 'sp_spaceused ''?''' &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br />

</div>


I can use this syntax to retrive all the size of the table. Can I also retrive the datecreated of the table ?

EXEC       sp_msforeachtable 'sp_spaceused ''?'''      


<div>
u can get the datecreated from SYSOBJECTS crdate column
</div>


u can get the datecreated from SYSOBJECTS crdate column

<div>
change it to<br />
<br />
and crdate &lt;= dateadd(m,-1,getDate())
</div>


change it to

and crdate <= dateadd(m,-1,getDate())

<div>
Wonderful Thank you :) <br />

</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I have Database named MyDatabase.<br />
We have to create the tables for certain reasons. Though, we have to use those table for some days only. After that the table is considered as expired. <br />
I want to delete the tables which are created before certain date. Example would be one month ago.<br />
All our tables starts with &quot;MyTmp_&quot;?<br />
<br />
How can I do using a script. I can write scheduled job which does this once a month.<br />
<br />
Kindly guide me.<br />
<br />
Regards,
</div>
</div>


Hello,

I have Database named MyDatabase.
We have to create the tables for certain reasons. Though, we have to use those table for some days only. After that the table is considered as expired. 
I want to delete the tables which are created before certain date. Example would be one month ago.
All our tables starts with "MyTmp_"?

How can I do using a script. I can write scheduled job which does this once a month.

Kindly guide me.

Regards,

Script: How to delete Table created before some date

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.