Temporary Table

seralasu

New Member

Join Date: Oct 2006

Posts: 34
#1

Temporary Table

May 16 '07, 11:07 AM

Hi,
I don't know How to create temproray table or Heap table and between difference.
I'm happy If you help me.
Tags: None
code green

Recognized Expert Top Contributor

Join Date: Mar 2007

Posts: 1726
#2

May 16 '07, 12:28 PM

Code:

CREATE TEMPORARY TABLE tablename (fieldname INT, 2fieldname VARCHAR 30)

This table will remain in scope while the creating script is active. Then the table will be dropped
Comment

Comment