Query record in tables..

I would like to know, the general consept how to query the tables?

I have the piece of SQL command here..

Code:

---

sSqlCmd = "CREATE PROCEDURE UMNO as SELECT PLOT FROM Pemilik"

---

How I can delete the UMNO Query tables?I got error because this query tables already exist.. so I want to delete this query tables if found

Why not just:

Code:

---

sSqlCmd = "SELECT PLOT FROM Pemilik"

---

?

Code:

---

IF EXISTS(SELECT 1 FROM sys.objects WHERE OBJECT_ID = OBJECT_ID(N'tablename') AND type = (N'U'))
BEGIN
  DROP TABLE tablename
END

---