Check out GetOleDbSchemaTable. That should give you the data you need.
Regards,
Steven Fraser
-----Original Message-----
From: Jeff Block [mailto:[EMAIL PROTECTED]]
Sent: 24 April 2002 22:11
To: [EMAIL PROTECTED]
Subject: [DOTNET] Checking Existance and Creating SqlServer Objects
Is there a way to query for the existance of tables and stored procedures
from C#? From VB6 land I was using SQLDMO, but can't seem to figure it
out through interop in C#. I want to be able to create tables, but only
if they don't exist first, stored procedures I would most likely want to
just drop and recreate. Any thoughts would be very appreciated!
TIA...
Jeff
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
______________________________________________________________
CONFIDENTIALITY NOTICE
This communication and the information it contains is intended for the person or
organisation to whom it is addressed. Its contents are confidential and may be
protected in law. Unauthorised use, copying or disclosure of any of it may be
unlawful. If you are not the intended recipient, please contact us immediately.
The contents of any attachments in this e-mail may contain software viruses, which
could damage your own computer system. While Marlborough Stirling has taken every
reasonable precaution to minimise this risk, we cannot accept liability for any damage
which you sustain as a result of software viruses. You should carry out your own
virus checking procedure before opening any attachment.
Marlborough Stirling plc, Registered No. 3008820,
Allen Jones House, Jessop Avenue, Cheltenham, Gloucestershire, GL50 3SH
Tel: 01242 547000 Fax: 01242 547100
http://www.marlborough-stirling.com
The following companies are subsidiaries of Marlborough Stirling plc and are
registered in England and Wales at the above address:
Marlborough Stirling PLC, Registered No. 3008820
The Marlborough Stirling Group PLC, Registered No. 1855353
Marlborough Stirling Administration Limited, Registered No. 2341195
Metgem Limited, Registered No. 02341195
You can read messages from the DOTNET archive, unsubscribe from DOTNET, or
subscribe to other DevelopMentor lists at http://discuss.develop.com.
