Tables are used to store data and define the relationships for data in them. Tables consist of rows and columns. Each column carries a particular kind of information, such as a phone number or a name, while each row specifies a particular entry.
When you first create an UltraLite database, the only tables you will see are the system tables. System tables hold the UltraLite schema. You can hide or show these tables from Sybase Central as needed.
You can then add new tables as required by your application. You can also browse data in those tables, and copy and paste data among existing tables in the source database or even among other open destination databases.
In UltraLite, you can only create base tables, which you declare to hold persistent data. UltraLite does not support global temporary or declared temporary tables.
Creating UltraLite tables
Adding a column to an UltraLite table
Altering UltraLite column definitions
Deleting UltraLite tables
Browsing the information in UltraLite tables
Data copying and pasting to or from UltraLite databases
Entity-relationship diagrams from the UltraLite plug-in
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|