Click here to Skip to main content
15,860,972 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to create table in trigger
Posted
Comments
thatraja 10-Jan-14 3:20am    
why? That's not trigger's purpose
Abhilask kumar 10-Jan-14 3:49am    
i mean can i create table in after trigger.
Thomas ktg 10-Jan-14 3:50am    
Refer here,
http://forums.mysql.com/read.php?99,121849,122609#msg-122609
I think It is also applicable for SQL-Server.
What have you tried and where is the problem?

please check !!
XML
http://msdn.microsoft.com/en-us/library/ms189799.aspx
The following Transact-SQL statements are not allowed in a DML trigger:
ALTER DATABASE
CREATE DATABASE
DROP DATABASE
RESTORE DATABASE
RESTORE LOG
RECONFIGURE


Thanks
 
Share this answer
 
it is simple
SQL

>create table tmp_tab([id] int,[name] varchar(20)).
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900