This discussion is archived
1 Reply Latest reply: Jul 3, 2012 9:17 AM by gdarling - oracle RSS

SQL Server Create table Syntax

860250 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points