Sybase 12.4.2 100, 101, 103, 104, 106, 107, 114, 116, 118, 123, 124, 125, 127, 128, 129, 130

		Contents
	Steps in establishing a connection	77
	Locating the interface library	78
	Assembling a list of connection parameters	79
	Locating a server	81
	Locating the database	83
	Server name caching for faster connections	84
	Interactive SQL connections	85
	Connecting from other databases	85
	Using an integrated login	86
	Using integrated logins	87
	Security concerns: unrestricted database access	90
	Setting temporary public options for added security	91
	Network aspects of integrated logins	92
	Creating a default integrated login user	92
	Troubleshooting startup, shutdown, and connections	93
	What to do if you can’t start Adaptive Server IQ	93
	What to do if you can’t connect to a database	95
	Stopping a database server in an emergency (UNIX)	96
	Resolving problems with your DBISQL window on UNIX	96
CHAPTER 3	Working with Database Objects	99
	Building Your Adaptive Server IQ Databases	99
	Designing your database	99
	Tools for working with database objects	100
	A step-by-step overview of database setup	101
	Extending data definition privileges	103
	Selecting a device type	104
	Allocating space for databases	104
	Working with databases	106
	Creating a database	107
	Adding dbspaces	114
	Dropping dbspaces	116
	Dropping a database	118
	Working with tables	118
	Creating tables	118
	Altering tables	123
	Dropping tables	124
	Creating primary and foreign keys	125
	Table information in the system tables	127
	Working with views	127
	Creating views	128
	Using views	129
	Modifying views	130
	Permissions on views	130

v