if Exists(SELECT * FROM information_schema.tables where Table_name = 'Domain') begin print 'true' end else begin create table Domain ( ID int primary key not null, Dom_ID int references Domain (ID), Title nvarchar(200), Name nvarchar(200), Priority int not null default 0, IsActive bit not null default 1, Description nvarchar(1000) ) end