XLeratorDB Utilities (FREE)
XLeratorDB/utilities lets you confirm that your server registration information is correct before you purchase an XLeratorDB package.
In addition, the package also includes a number of handly utility functions commonly found in T-SQL scripts, such as checking for existence of a databse, table, or other object. For example:
- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].
[mytable]') AND type in (N'U'))
DROP TABLE [dbo].[mytable]
- IF (wct.TableExists('dbo','myTable') <> 0) DROP TABLE dbo.myTable