In one of my Client code I have seen,
Create table Students (id int, name varchar 100) on PRIMARY
What is the importance of "on" in create table.?? Thank you in advance.
Asked
Active
Viewed 1,434 times
-2
felix Antony
- 1,450
- 14
- 28
-
why down vote it... i did not see that post when I searched in stackoverflow. Then how can I know this question is there??? This is not good. I can delete the post. but downvotting is not a good practice for this post. – felix Antony Jul 07 '14 at 07:13
-
1why your question taged as `SQL-Server` and `mysql`. – mehdi lotfi Jul 07 '14 at 07:28
-
i thought this query is common in my sql and mssql... – felix Antony Jul 07 '14 at 09:23
2 Answers
2
Specifies the partition scheme or filegroup on which the table is stored
mehdi lotfi
- 11,194
- 18
- 82
- 128
-1
When you create a database in Microsoft SQL Server you can have multiple file groups, where storage is created in multiple places, directories or disks. Each file group can be named. The PRIMARY file group is the default one, which is always created, and so the SQL you've given creates your table ON the PRIMARY file group.
See the question here
