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

    SQL Server Create table Syntax

    860250
      Hi,

      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:
          http://forums.devshed.com/ms-sql-development-95/simple-question-on-primary-167752.html

          Greg