Question

how to check if table exist and if it doesnt exist create table in sql server 2008

Answer 1

BEGIN
IF NOT EXISTS (SELECT [ name] FROM sys.tables WHERE [name] = 'xxtable' ) then
CREATE TABLE xxtable
(
col1 INT,
col2 VARCHAR(30),
col3 VARCHAR(30),
col4 INT
);
dbms_output.put_line('Table Ceated Table');
ELSE
dbms_output.put_line('Table Already exists');
END;