Prakash Mondal

Prakash Mondal

  • 1.9k
  • 288
  • 182.1k

Can a trigger create a table ?????

Mar 9 2013 4:43 AM
1st Table:
create table subject_store(sub_name varchar(20),sub_id varchar(20));

=====Trigger========

create or replace trigger ttrr
after insert on subject_srote
for each row
begin

create table :new.sub_name(qs_no varchar(20), qs varchar(20),qs_ans varchar(20));
end;
/

Problem:
create command can't accepted........

but, how it can be happen in sql server....????????

Answers (1)