Hi,
I am trying to find a table (demoraphs) that is created dynamically. I
need to find if it exists in the database so can delete and if it does
not exist to create it. I am creating the application in c sharp( i am
a newbie in c sharp).
i // cmd.CommandText = "IF OBJECT_ID('demographs','U') IS NOT NULL
DROP TABLE demographs";
ii // cmd.CommandText = "IF EXISTS(SELECT TABLE_NAME FROM
INFORMATION_SCHEMA.TABLES
if (conn.State == ConnectionState.Closed)
conn.Open();
cmd.ExecuteNonQuery();
this section of code gives me an error if i use either i or ii the
error being expecting update,select,delete or insert. Does anyone know
how to select access tables using c sharp so that I can delete and
update the table demographs.
