sybase的安装使用和视图的创建与维护实验.pdf

北京邮电大学 实验报告 课程名称 数据库系统原理 实验内容 实验一实验二 实验名称SYBASE 数据库安装、创建与维护实验 班级 2008211316 姓名 张荣/周志 指导老师 成绩_________ 2010 年 3 月 28 日 1 实验一 SYBASE 数据库安装、创建与维护实验 一、实验目的························································································································3 二、实验平台及环境··············································································································3 三、实验内容························································································································3 四、实验步骤及相关结果分析································································································4 1 ．sybase 安装···································································································································4 （1） 在windows2007 上安装并运行sybase··············································································4 （2 ）练习启动和停止数据库服务································································································5 （3 ）通过Adaptive Server Enterprise 连接数据库·······································································5 （4 ）熟悉Adaptive Server Enterprise 的各项功能，了解Sybase 数据库的主要对象··············6 （5 ）了解Sybase 在安装时自动创建的数据库和几类系统表·················································10 2.数据库创建与维护·························································································································12 ◆Adaptive Server Enterprise 管理工具完成任务········································································12 ◆交互式的Transact_SQL 语句完成任务····················································································16 五、实验小结··········