I am creating a table with SQL code " CREATE TABLE

tab1(name char(40), ...) but before creating this one

I need to check if it already exist.

Can someone help me to check if a table exist in a

database with an ASP code ?



Thanks

If using ADO then you can use OpenSchema to read the structure of the DB.



> -----Original Message-----

> From: Ghislain DZOU [mailto:ghygi@y...]

> Sent: 16 August 2001 12:39

> To: ASP Databases

> Subject: [asp_databases] Checking the existense of TABLE

>

>

>  I am creating a table with SQL code " CREATE TABLE

> tab1(name char(40), ...) but before creating this one

> I need to check if it already exist.

> Can someone help me to check if a table exist in a

> database with an ASP code ?

>

> Thanks