How to remove primary key in datatable
How to remove primary key in datatable
trisandymon
Posts: 5Questions: 0Answers: 0
I wanna show table SQL View which has no primary key in it. but since datatable require primary key in processing server. How could i make this thing done?
This discussion has been closed.
Replies
DataTables does not require a primary key value. The demo server-side processing script makes use of one, but fundamentally it isn't required for read only data. Only when you want to write data back (e.g. with Editor) would it be required.
Are you sure you need server-side processing?
Allan
I need the server-sideside processing because i have data with 800.000 record. What should i do then if i wanna use server-side with a table with no primary key?
This is where it is used.
The primary key is used to quickly count rows, but you could change it to any other column name you want. It would just be slower.
Allan