How is a Sybase table created?

Showing Answers 1 - 3 of 3 Answers

Ganapathi Masilamani

Jul 5th, 2007

Live table will be created using:
1.
Create table

(
column name datatype
)

2.
Select * into from

e-x: select * into new_emp from emp

Temp Table will be created using:
1.
Create table &LT;#table name&GT;
(
column name datatype
)

2.
Select * into &LT;#live table&GT; from
e-x: select * into #emp from emp