1. The targets of ASE and ASA are different.The Sybase Database Engine has three products:The ASA lightweight database server is suitable for mobile computing (PDA, mobile phones with operating systems, etc.), Embedded Computing (POS machines,
When the sybase asa database is shut DOWN abnormally, it is prone to exceptions, such as table or index errors. The trouble is that the database will go DOWN when you delete a table using drop table t_name. Below are two common restoration methods:
In Sybase central tools, we can often see the following pages:650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/89/67/wKiom1gRyE_zM-JyAABH3iPUDEM213.png "title=" Sybasecentral001.png "style=" border:1px solid #000000; "alt="
Sybase was founded in 1984The company name "sybase" is taken from the meaning of "system" and "Database. Bob Epstein, one of the founders of Sybase, is a major designer of the INGRES Emy edition (relational database model product in the same period
Several common SQL functions for querying meta information in Sybase ASA:
sp_column_privileges Unsupported sp_columns table-name [, table-owner ] [, table-qualifier] [, column-name] 返回指定列的数据类型 sp_databases Unsupported sp_datatype_info Unsupported
SYBASE ASA Database when you encounter an abnormal shutdown, it is easy to have exceptions, such as: Table or index error, the trouble is to use drop table T_name Delete tables when the database will down. Here are my two common ways to recover:
----------------------------------------------------------------------------
---- This is andkylee's personal originality. Please repost it with respect to the author's Labor achievements;
---- The original source must be specified for
Tools that have been developed to recover data from Sybase SQL anywhere DB files are now available.This tool supports versions such as Asa v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0. The tools to recover Sybase SQL anywhere should be the first in
Download a DBeaver1.4 version from http://dbeaver.jkiss.org/, the software is completely free, the function and Dbvisualizer compared, slightly less, but simple and easy to use, operating efficiency seems to be higher. This is an example of Sybase
It is an important feature to determine whether a DBMS is powerful and whether external stored procedures are easy to create and use.
The ASA database has long been supporting the use of C, CLR (. NET), Java and other programming languages to create
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.