Example you need to Change table locking schema you need to consider below points
1) Changing APL to data-only need to copy data rows to new pages.
2) It will rebuild the indexes on the table if any.
3)This requires many steps –
I)Nedd sufficient space to copy tables and index on database usually 1.5times the space of tables
You can check by sp_spaceused table_name
Time required this operation depends on size of tables and number of index on tables
Please note : changing from datapages locking to datarows or vice versa does not require to copy or rebuild index just update in system tables would be fine.
Use db_name
go
alter table table_name lock datarows
go
You can check constraint and it’s type by using
sp_helpconstraints table_name
go
#sybasease #database #ase #sap #dba #sybasedba