List Tables on SQL Server

 SELECT

  name,

  crdate

FROM

  SYSOBJECTS

WHERE

  xtype = 'U' and name like '%Shi%';

GO

select * from CommandLog where command like 'ALTER INDEX%';