RecorteX

descargar
 
IF EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' AND TABLE_NAME='tbl_mexicalas') SELECT 'tablename exists.'
 

descargar
 
IF EXISTS (SELECT * FROM syscolumns WHERE id = object_id('tbl_clientes') AND name = 'cNumGrupo')
begin
	print('yes')
end