delete [message #72152] |
Wed, 26 March 2003 20:02 |
FIRMAN
Messages: 1 Registered: March 2003
|
Junior Member |
|
|
I have one question, how I can delete table in sql?.
|
|
|
Re: delete [message #72153 is a reply to message #72152] |
Thu, 27 March 2003 01:55 |
Uwe
Messages: 260 Registered: February 2003 Location: Zürich, Switzerland
|
Senior Member |
|
|
Hi,
two ways ....
1.) if table is empty you can drop table xxxx
2.) if table is not empty with drop table xxxx cascade
hope that helps
Uwe
|
|
|
Re: delete [message #72156 is a reply to message #72152] |
Thu, 27 March 2003 15:17 |
Anand
Messages: 161 Registered: August 1999
|
Senior Member |
|
|
Your question is not clear ...
Do you want to DELETE the table or DROP it. DROP will completely remove the table from the database. DELETE will remove only the rocords in the table. The table definition will be intact.
|
|
|