Hi all, someone could advice me in which is the simplest way of knowing
if a table with a specific name already exists in a sql server database?
 
thanks

select * from dbo.sysobjects where id = object_id(N'[dbo].[TableName]') and
OBJECTPROPERTY(id, N'IsUserTable') = 1)

----- Original Message -----
From: "DT-Rene Vazquez" <renevazquez@c...>
To: "ADO.NET" <ado_dotnet@p...>
Sent: Tuesday, December 24, 2002 1:20 AM
Subject: [ado_dotnet] verify for table


> Hi all, someone could advice me in which is the simplest way of knowing
> if a table with a specific name already exists in a sql server database?
>
> thanks
>
>
> ===
> Fast Track ADO.NET with C# is a concise introduction to the concepts,
techniques, and libraries that you will need in order to start using ADO.NET
in your applications. The book covers DataSets and Typed DataSets, accessing
data using DataReaders and DataAdaptors, the close relationship between
ADO.NET and XML, how and where to use ADO.NET in your enterprise
applications, and how to use Web Services and ADO.NET to easily pass data
between applications.
> http://www.wrox.com/books/1861007604.htm