Identifying database for a specific command

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Identifying database for a specific command

Message

From

22/03/2011 15:31:26

22/03/2011 15:24:05

General information

Forum:

Microsoft SQL Server

Category:

Scripting

Title:

Environment versions

SQL Server:

SQL Server 2008

Application:

Web

Miscellaneous

Thread ID:

01504553

Message ID:

01504557

Views:

>IF EXISTS (select 1 from myDB.sys.Objects WHERE OBJECT_ID = OBJECT_ID(N'MyTable') AND type = (N'U')) PRINT 'TEST'

>
>Alternatively,
>

>IF EXISTS (select 1 from MyDB.INFORMATION_SCHEMA.Tables where TABLE_Name = 'MyTable') PRINT 'TEST'

Thanks