Sybase Alter Database

Sybase Alter database used to increase the database size. When we alter database two things one its size changes and another is record updated in the sysdatabases table of master database.

Syntax to Sybase Alter Database:

alter database database_name 
	[on {default | database_device} [= size]
		[, database_device [= size]]...] 
	[log on {default | database_device} [= size]
		[, database_device [= size]]...] 
	set { [durability = { no_recovery | at_shutdown | full}]
      		 [[,] dml_logging = {full | minimal} ]
    		 [[,] template = { database_name | NULL}]}
	[with override]
	[for load]
	[for proxy_update]

Examples:

1. We are going to add space 10MB to the database r2school2.

alter database r2schools  on data02='10M'
go

Output:

2. Verify the database details by running sp_helpdb database_name.