Can a trigger create a table ?????
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....????????