Previous Topic

Next Topic

Book Contents

Book Index

Sybase - Admin notes


When you create a table, you will notice that columns have two parameters - Default Value and Default Object.

Dropping Indexes

By default, you can only drop indexes on tables for which you are the owner. If you wish to drop the index on tables owned by another user, you must first use the setuser command.

Example: to drop index custix1 on table test.customers:

setuser 'test'

drop index customers.custix1


Advanced Query Tool
© 2023 Cardett Associates Ltd. All rights reserved.