var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: selecting tables that meet certain criteria
Is there a quick way to select all the tables in the DB that don't have certain column in the table, so for example getting a list of all tables that don't have columns: A, B or C?
It's easy... just cross the sysobject table and the syscolumns table of your database.
Sorry, I'm quite new to SQL, could you explain further?
If you want names of the tables that do not have the
columns say "author_name" or "city" then you could
try the following piece of code
select distinct a.name as table_name
from sysobjects a, syscolumns b
where a.xtype= 'U'
and a.id = b.id
and b.name not in ( 'author_name', 'city')
Thank you, that was very helpful!!!!