1 Reply Latest reply: Jul 3, 2012 11:17 AM by gdarling - oracle RSS

    SQL Server Create table Syntax


      I am new to SQL server. I have below statement can you please let me know what is ON [PRIMARY]. I want to write a similar create script to be written for Oracle & need to understand the importance of ON [PRIMARY]

      Create table [emp]
      [e_name] [varchar] (255) NOT NULL,
      [e_sal] [decimal] (20,0) NOT NULL
      ) ON [PRIMARY]
        • 1. Re: SQL Server Create table Syntax
          gdarling - oracle
          You'll probably have better luck posting that question on a MS forum, or at best one of the DBA Oracle forums, as the question is unrelated to Oracle Providers for ASP.NET.

          However a quick google returns this as the first result: