Is it possible to check existence of object before accesing? : The Official Microsoft ASP.NET Forums

ASP.NET

Complete Thread

- Reply
hans_v

All-Star

35986 Points

6550 Posts
Re: Is it possible to check existence of object before accesing?

Sep 13, 2011 07:04 AM|LINK
For Access use:
```
SELECT Count(*) FROM MSysObjects WHERE [Name]=@tablename AND [Type]=1
```
Type=1 is a table. If you want to check if a query with a particular name exists, use [Type]=5
- Edited by hans_v on Sep 13, 2011 07:04 AM
- Edited by hans_v on Sep 13, 2011 07:06 AM