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

Create proc usp_alldatabases

<span>as</span>

begin

 

declare @script <span>as</span> nvarchar(2000)

<span>if</span>  exists(select 1 from sysobjects <span>where</span> name=<span>'tab_alltables'</span>) drop table tab_alltables

create table tab_alltables (db nvarchar(1000), tab nvarchar(1000),cdate datetime)

declare c cursor  <span>for</span>

select <span>'insert into tab_alltables (tab,db,cdate) select name,'</span><span>''</span>+name+ <span>''</span><span>',crdate from '</span> +name+<span>'..sysobjects where xtype='</span><span>'u'</span><span>''</span> from master..sysdatabases  <span>where</span> dbid>4

open c

fetch c into @script

<span>while</span> @@fetch_status=0

begin

exec (@script)

 

print @script

fetch c into @script

end

close c deallocate c

select * from tab_alltables --You can add your criteria here to serach <span>for</span> a particular table name

end