SR5V6VZe

1BEGIN
2	if exists(SELECT * FROM INFORMATION_SCHEMA.TABLES where TABLE_NAME='TheTable')
3		Print 'The table already exists'
4	else
5		BEGIN
6			CREATE TABLE TheTable(ID int NOT NULL PRIMARY KEY, 
7							LastName nvarchar(40), 
8							FirstName nvarchar(40), 
9							Address nvarchar(100),
10							City nvarchar(50)
11						);
12			Print 'The table was successfuly created'
13		END
14END