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