--先建记录日志表ddl_log
USE [test_db]
GO
CREATE TABLE [dbo].[ddl_log](
[log_id] [int] IDENTITY(1,1) NOT NULL,
[post_time] [datetime] NULL,
[server_name] [varchar](100) NULL,
[database_name] [varchar](100) NULL,
[login_name] [varchar](100) NULL,
[target_object_name] [varchar](100) NULL,
[event_type] [varchar](100) NULL,
[command_text] [varchar](8000) NULL,
[client_host_name] [varchar](128) NULL,
[client_ip] [varchar](20) NULL,
[client_mac] [varchar](20) NULL,
[client_program_name] [nvarchar](128) NULL,
[event_instance] [xml] NULL,
PRIMARY KEY CLUSTERED
(
[log_id] ASC
))