What does ON [PRIMARY] mean?

by

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 MSDN for the full syntax.

More Related Contents:

  1. How to create multiple one to one’s
  2. Composite Primary key vs additional “ID” column?
  3. Single or multiple databases
  4. SQL – How to store and navigate hierarchies?
  5. T-SQL Cast versus Convert
  6. A beginner’s guide to SQL database design [closed]
  7. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  8. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  9. single fixed table with multiple columns vs flexible abstract tables
  10. How to design a database for User Defined Fields?
  11. How to run a stored procedure in sql server every hour?
  12. Splitting the string in sql server
  13. Should I design a table with a primary key of varchar or int?
  14. Why do you create a View in a database?
  15. Need to list all triggers in SQL Server database with table name and table’s schema
  16. Database EAV Pros/Cons and Alternatives
  17. How can I do a BEFORE UPDATED trigger with sql server?
  18. Deferrable Constraints in SQL Server
  19. MySQL – how to front pad zip code with “0”?
  20. How to sum up time field in SQL Server
  21. Know relationships between all the tables of database in SQL Server
  22. Can SQL Server Express LocalDB be connected to remotely?
  23. The object ‘DF__*’ is dependent on column ‘*’ – Changing int to double
  24. SQL: Using NULL values vs. default values
  25. Using SQL Server as a DB queue with multiple clients
  26. Suggestions for implementing audit tables in SQL Server?
  27. SQL Server search using like while ignoring blank spaces
  28. How do I list all the columns in a table?
  29. Space used by nulls in database
  30. can we have a foreign key which is not a primary key in any other table?

Leave a Comment