Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dpwhitedp
Starting Member
5 Posts |
 Posted - 2004-05-05 : 10:35:41
|
| I need some code to determine if a tablehas been created in the database. This isvariable so I would type in a table name andit has to come back and tell me if it exists |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2004-05-05 : 12:13:24
|
| http://www.mvps.org/access/tables/tbl0001.htm====Paul |
 |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-05-09 : 23:31:31
|
| Another way is to query the MSysObjects table in Access:SELECT Count(Type) FROM MSysObjects WHERE Name = 'table' AND Type = 1Tim |
|
|
|
|
|
|
check to see if a specific table exists