SQL里在过程过程里创建表

--存储过程已经存在就删除了再创建

if exists (select name from sysobjects

where name = 'create_table_chats' and type = 'p')

drop procedure create_table_chats

go

--创建存储过程

create procedure create_table_chats

@table_name varchar(50)

as

exec('--新建表

use CIM_DB

create table ' + 'Table_' + @table_name +'

( ID int not null identity(0,1),

Chats varchar(50),

Time datetime,

primary key(ID))')

go