取得 SQL-Server 資料庫的所有 Table Name 的 T-SQL

select name from sysobjects
where xtype='U'
and id not in
(select id from syscolumns where name='colname')
order by name