SQL MS SQL Datenbank und Tabelle Create

-- Get the SQL Server data path
DECLARE @data_path nvarchar(256);
SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)
                  FROM master.sys.master_files
                  WHERE database_id = 1 AND file_id = 1);

if not exists (select * from sysdatabases where name = 'DBNAME')
begin
EXECUTE('create database DBNAME on primary
	( 
		NAME = DBNAME,
		FILENAME =  '''+@data_path+ 'DBNAME.mdf'',
		SIZE = 3MB,
		MAXSIZE = 10MB,
		FILEGROWTH = 1MB
	)
LOG ON
( NAME = DBNAME_log,
    FILENAME = '''+ @data_path + 'DBNAME_log.ldf'',
    SIZE = 3MB,
    MAXSIZE = 25MB,
    FILEGROWTH = 5MB )'
);
end

if not exists (SELECT name FROM sysobjects WHERE name = 'TABELLENNAME' AND OBJECTPROPERTY(id,'IsUserTable') = 1)
	AND exists (select * from sysdatabases where name = 'DBNAME')
begin
create table [DBNAME].[dbo].[TABELLENNAME] 
	(
		......
	);
end

if exists (SELECT name FROM sysobjects WHERE name = 'TABELLENNAME' AND OBJECTPROPERTY(id,'IsUserTable') = 1)
begin
	insert into [dbo].[TABELLENNAME] values (...);
end