my problem is the following...

Sometimes I create table "X" in my database, I meed someting to know if I
have table "X" already created, can you help me with that???

Thank you in advance...

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote

If the table is named X, this is the code that Management Studio will create
for you:
SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type
in (N'U')

What do you want to do if the table exists?
If you want to stop the operation, then something like:
IF NOT EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
CREATE TABLE X ...

If you want to drop the table and then create table X, then do something
like:
IF EXISTS (SELECT * FROM sys.objects
WHERE object_id = OBJECT_ID(N'[dbo].[X]') AND type in (N'U'))
DROP TABLE [dbo].[X]
GO
CREATE TABLE X ...

--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Deiny García Pérez" <deiny (AT) nnn (DOT) com> wrote