SQLServer中列出数据库的所有表的创建时间代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 SQLServer中列出数据库的所有表的创建时间

作者:wintersun / 发布于2012/7/9/ 667

列出数据库的所有表的创建时间

<div>
<pre class="alt">
Create proc usp_alldatabases</pre>
<pre><span class="kwrd">as</span></pre>
<pre class="alt">
begin</pre>
<pre>
 </pre>
<pre class="alt">
declare @script <span class="kwrd">as</span> nvarchar(2000)</pre>
<pre><span class="kwrd">if</span>  exists(select 1 from sysobjects <span class="kwrd">where</span> name=<span class="str">'tab_alltables'</span>) drop table tab_alltables</pre>
<pre class="alt">
create table tab_alltables (db nvarchar(1000), tab nvarchar(1000),cdate datetime)</pre>
<pre>
declare c cursor  <span class="kwrd">for</span></pre>
<pre class="alt">
select <span class="str">'insert into tab_alltables (tab,db,cdate) select name,'</span><span class="str">''</span>+name+ <span class="str">''</span><span class="str">',crdate from '</span> +name+<span class="str">'..sysobjects where xtype='</span><span class="str">'u'</span><span class="str">''</span> from master..sysdatabases  <span class="kwrd">where</span> dbid>4</pre>
<pre>
open c</pre>
<pre class="alt">
fetch c into @script</pre>
<pre><span class="kwrd">while</span> @@fetch_status=0</pre>
<pre class="alt">
begin</pre>
<pre>
exec (@script)</pre>
<pre class="alt">
 </pre>
<pre>
print @script</pre>
<pre class="alt">
fetch c into @script</pre>
<pre>
end</pre>
<pre class="alt">
close c deallocate c</pre>
<pre>
select * from tab_alltables --You can add your criteria here to serach <span class="kwrd">for</span> a particular table name</pre>
<pre class="alt">
end</pre>
</div>

试试其它关键字

同语言下

可能有用的

wintersun贡献的其它代码(3)