Answer Posted / jayakumar

Temporary tables are created in the tempdb database. To
create a temporary table, you must have created table
permission in tempdb.
You can create temp tables in 2 ways :
1. Create table #tablename
2. Create table tempdb..tablename

a).If you create the table as per the above mentioned ways,
the table will get dropped automatically when the
session/procedure ends or you drop it manually.
b).If you don’t use the above mentioned ways and use
only "create table table name" command in tempdb the table
will stay there as long as you drop in manually.
c).If you create a table in any other database other than
tempdb, it will not be a temp table.

How to manually drop a table in sybase?

1016

---

What data types does sybase support?

884

---

We have lost the sa password, what can we do?

860

---

Explain index covering? List its merits.

959

---

Explain intimate shared memory(ism)

902

---

How can I improve throughput in sybase?

925

---

How can I tell the datetime my server started?

965

---

Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?

849

---

What is coalesce in sybase?

941

---

Explain coalesce.

939

---

How do I configure identities in sybase?

859

---

Is sybase owned by sap?

899

---

What mandatory options are required for bcp command utility?

934

---

You need to remove the affected rows and dashes. How would you do that?

930

---

Is sybase open source?

875

---