CREATE TABLE dbo.AuditDDLEvents
(
  id               INT      NOT NULL IDENTITY,
  posttime         DATETIME  ,
  eventtype        sysname  ,
  loginname        sysname  ,
  schemaname       sysname  ,
  objectname       sysname  ,
  CONSTRAINT PK_AuditDDLEvents PRIMARY KEY(id)
);
go

CREATE TRIGGER [trg_create_tbl] ON DATABASE FOR CREATE_TABLE
AS
SET NOCOUNT ON;
DECLARE @eventdata AS XML = eventdata();


ROLLBACK

INSERT INTO dbo.AuditDDLEvents(
  posttime, eventtype, loginname, schemaname, objectname)
  VALUES( @eventdata.value('(/EVENT_INSTANCE/PostTime)[1]',         'VARCHAR(23)'),
          @eventdata.value('(/EVENT_INSTANCE/EventType)[1]',        'sysname'),
          @eventdata.value('(/EVENT_INSTANCE/LoginName)[1]',        'sysname'),
          @eventdata.value('(/EVENT_INSTANCE/SchemaName)[1]',       'sysname'),
          @eventdata.value('(/EVENT_INSTANCE/ObjectName)[1]',       'sysname')
          );