How would you add a section to a table?



How would you add a section to a table?..

Answer / Chandra Kumar Jaisawal

To add a section (or partition) to a table in SQL Server, you can use the ALTER TABLE PARTITION BY RANGE or LIST clause. This allows you to divide large tables into smaller, more manageable sections based on specific criteria.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is index?

1 Answers   Cap Gemini,


What are the database objects? : SQL Server Architecture

1 Answers  


What are scalar functions in sql?

1 Answers  


How do I start sql server agent automatically?

1 Answers  


How do I start sql server?

1 Answers  


Explain Geometry datatype in sql server 2008 with example

1 Answers   Infosys,


What are the types of model in sql server and explain

2 Answers   TCS,


How to declare and use cursor variables?

1 Answers  


How to change location of errorlog in SQL?

2 Answers   ABC, IBM,


What is the difference between cube operator and rollup operator? : SQL Server Architecture

1 Answers  


How to create a view on an existing table in ms sql server?

1 Answers  


What is dml command?

1 Answers  


Categories