how to create table inside stored proc

• Loulan Chang

  Newbie

  Points: 1

  More actions

  September 18, 2007 at 7:40 pm

  #118659

  I am new to T-SQL. How do I write the portion in blue?

  set quoted_identifier on

  GO

  if exists (select * from sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

  -- need to output message that MyTable already exists

  else

  -- how to create the table here?

  CREATE TABLE "dbo"."MyTable" (

   "username" varchar (64) NOT NULL ,

   "moduleID" varchar (100) NULL

  )

  end if;

  GO

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  September 18, 2007 at 9:56 pm

  #734463

  if exists (select * from sysobjects where id = object_id(N'[dbo].[MyTable]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

  PRINT 'MyTable already exists'

  else

  CREATE TABLE dbo.[MyTable] (

  [username] varchar (64) NOT NULL ,

  [moduleID] varchar (100) NULL

  )

  end if;

  _____________
  Code for TallyGenerator