TallyList : mailing list management, archiving, and analysis

Archive of:
CF-Talk
Cold Fusion - Technical

home
24 hour view
quick stats
weekly updates

all tallylists
corporate solutions
archive your favorite
help / feedback

About Cold Fusion :
product's home
product's list home

Archived TallyList / CF-Talk:
Subject: RE: SQL 7.0 (checking for the existence of a table)

Peter Stolz (16p/+0r) Posted: Sunday 13 May 2001
This post: 516 views, +0 rating

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME = '#SOME_TABLE_NAME#'

HTH

-----Original Message----- From: Brook Davies [mailto:brook@maracasmedia.com] Sent: Sunday, May 13, 2001 6:47 PM To: CF-Talk Subject: SQL 7.0 (checking for the existence of a table)

Is it possible (without using a stored procedure) to check for the existence of a table in SQL 7.0? Thanks for the help.

Brook Davies MaracasMedia Inc.

Similar Subject Line Posts (+/- two weeks of this post)

RE: SQL 7.0 (checking for the existence of a table)	13 May 2001 (this post)	(516 v/ +0 r)
SQL 7.0 (checking for the existence of a table)	13 May 2001	(272 v/ +0 r)

Send a reply to the CF-Talk list!
	NOTE: Many lists will reject your post unless you have already registered with them. Also - don't forget the right account to send from (for those with multiple emails!)