Hi,

Anyone provide tips to create a database

Thanks!!!!!!!

Well, most employers don't tip. They offer a flat rate.

The general syntax for creation of a database in sybase is as follows
create database database_name
[on {default | database_device} [= size]
[, database_device [= size]]...]
[log on database_device [= size]
[, database_device [= size]]...]
[with override] - optional only when you put log and data on the same logical device(not recommended)
[for load] - optional supposed to be given only when user is ready to load the dump of userdatabase immediately after creation of the database. If the database created is new then there is no need for a forload option.

For additional information please refer system administration guide.