Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

sqlobject-admin(1) [debian man page]

SQLOBJECT-ADMIN(1)					      General Commands Manual						SQLOBJECT-ADMIN(1)

NAME
sqlobject-admin - manage your database as defined with SQLObject classes SYNOPSIS
sqlobject-admin [options] command DESCRIPTION
The sqlobject-admin tool included with SQLObject allows you to manage your database as defined with SQLObject classes. Some of the features include creating tables, checking the status of the database, recording a version of a schema, and updating the database to match the version of the schema in your code. COMMANDS
The following commands are recognized: help Show the help text. create Find the tables and create them. Existing tables are simply skipped. sql Show the SQL to create all the tables. drop Drop tables. Missing tables are skipped. execute Execute an arbitrary SQL expression. list List out all the found classes. status Show if tables are present in the database. record Record historical information about the database status upgrade Update the database to a new version (as created by record) OPTIONS
-c CONNECTION, --connection=CONNECTION Connection string for the database . -f FILENAME, --config-file=FILENAME Configuration file from which to get the connection to the database. -m MODULE, --module=MODULE A module to look in for classes. -p PACKAGE, --package=PACKAGE A package to look in. --class=CLASSMATCH Restricting the found classes to the matching classes. --egg=EGG_SPEC Egg description that should be loaded. AUTHORS
This manual page was written by Carl Chenet <chaica@ohmytux.com>. LICENSE
This package is licensed under the GNU Lesser General Public License. You can find the full text of the LGPL in /usr/share/common-licenses/LGPL in your Debian system. 06/03/2010 SQLOBJECT-ADMIN(1)

Check Out this Related Man Page

MDBTools(1)															       MDBTools(1)

NAME
mdb-tables - Get listing of tables in an MDB database SYNOPSIS
mdb-tables [-S] [-1 | -d delimiter] database DESCRIPTION
mdb-tables is a utility program distributed with MDB Tools. It produces a list of tables contained within an MDB database in a format suitable for use in shell scripts. OPTIONS
-S Show system tables. System tables are generally those beginning with 'MSys' -1 specifies that the tables should be listed 1 per line. -d delimiter specifies an alternative delimiter. If no delimiter is specified, table names will be delimited by a tab character, or by newline if the -1 option was specified. NOTES
ENVIRONMENT
MDB_JET3_CHARSET Defines the charset of the input JET3 (access 97) file. Default is CP1252. See iconv(1). MDBICONV Defines the output charset. Default is UTF-8. mdbtools must have been compiled with iconv. MDBOPTS semi-column separated list of options: o use_index o no_memo o debug_like o debug_write o debug_usage o debug_ole o debug_row o debug_props o debug_all is a shortcut for all debug_* options HISTORY
mdb-tables first appeared in MDB Tools 0.3. SEE ALSO
gmdb2(1) mdb-export(1) mdb-hexdump(1) mdb-prop(1) mdb-sql(1) mdb-ver(1) mdb-array(1) mdb-header(1) mdb-parsecsv(1) mdb-schema(1) AUTHORS
The mdb-tables utility was written by Brian Bruns. BUGS
Access allows for tables to have spaces embeded in the table name. You must specify a delimiter (-d) if you intend on piping the output of mdb-tables to a program such as awk or cut. 0.7 13 July 2013 MDBTools(1)
Man Page

13 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

viewing tables

I have completely blanked out on this and I have done it a million times. I need to modify some tables in unix. What is the command for opening/viewing the tables? Thanks so much. :o (2 Replies)
Discussion started by: itldp
2 Replies

2. UNIX for Advanced & Expert Users

writing database tables into a file in unix

I want to collect the database tables(Ex: Emp,Sal,Bonus...etc) in a file & give this file at the command prompt, when prompted for the tables list at command prompt. How can i do that ? Ex:- Import jason/jason1 tables=emp,sal,bonus log=j1.log i want to change this into Ex:- Import... (3 Replies)
Discussion started by: dreams5617
3 Replies

3. UNIX for Advanced & Expert Users

How to Update the database

I have to read one input file which will give me some tables info like TradeNo,MsgId,status etc... I have read that TradeNo from that input file and then look for that trade no in the database table and in the database I have to update the columns for that particular trade which I am getting fron... (7 Replies)
Discussion started by: madaans
7 Replies

4. Shell Programming and Scripting

change the contraints type of fields in database

how to disable the contraint type of a field (which is present in diffrent tables ) in database using a single unix script file. (4 Replies)
Discussion started by: shaksing
4 Replies

5. BSD

after update package...

Hi all^^ after upgrade joomla (1.5.7-1.5.11) this package , and then portaudit -Fda fetch: http://www.FreeBsd.org/ports/auditfile.tbz: No address record Couldn't fetch database. Old database restored. portaudit: Download failed what wrong??? (1 Reply)
Discussion started by: adamkong
1 Replies

6. UNIX Desktop Questions & Answers

Extracting data from tables and storing in a file

Hi I am trying to write a script to extract information from a database and save that info to a csv file. I am using sql, an oracle database I have no idea how to even begin this. Can somebody please help. (8 Replies)
Discussion started by: ladyAnne
8 Replies

7. UNIX and Linux Applications

SQL admin tool

Hi experts, I'm looking for a specific DB admin tool. I'm not looking for complicated BPM(business process management) software, what I need is just some additional functionality embedded within DB admin tool. What I need is the 1.Approvement system - whenever there is a... (4 Replies)
Discussion started by: hernand
4 Replies

8. Programming

Query to join two tables in SQL

Hi, I have 2 tables. Table1 name map_code data_code id aaa 2732C 3333B 10 bbb 1223F 2545v 11 ccc 12 Table2 name map_code data_code id text_description aaa 2732C 3333B 10 description 1 bbb 1223F 2545v 11 ... (3 Replies)
Discussion started by: vanitham
3 Replies

9. UNIX for Dummies Questions & Answers

Mysqldump certain tables

Hi, I have to upload part of my database periodically when i make changes to product data etc. However I only want to upload certain tables. We suffer from bandwidth chock here, so i want to write a couple of separate scripts that upload parts of the database that changed. The database is large... (5 Replies)
Discussion started by: timgolding
5 Replies

10. Shell Programming and Scripting

Scripts for exporting backup from selected tables of Oracle DB

dear all please help me ! i need a script for exporting the selected tables of oracle database installed on CentOs. i waiting your response. thanks and regards (6 Replies)
Discussion started by: amirzargaran
6 Replies

11. Programming

How to eliminate OR clause when joining tables?

HI Team I have q tricky question when joining 3 tables in Teradata DB.In the last line of my query , I am comparing one condition with C an B tables and its creating performance issue in returning the data . Basically I want to eliminate OR clause and try other approach.Is there any logic to... (3 Replies)
Discussion started by: Perlbaby
3 Replies

12. Programming

How to arhive hive external tables?

Hi Guys, Is there a way to check hive external tables which are created 90 days before and drop those tables along with underlying hdfs data. Can this be achieved in unix script? (10 Replies)
Discussion started by: Master_Mind
10 Replies

13. UNIX for Beginners Questions & Answers

Matching tables

Hello I have two tables like this Table1 Ab01 Ac01 Bd01 Xc01 Ab02 Ac02 Bd02 Xc02 Ab03 Ac03 Bd03 Xc03 Ab04 Ac04 Bd04 Xc04 Ab05 Ac05 Bd05 Xc05 and Table 2 like this Group_01.1 Bd03 Group_01.1 Ac03 Group_01.1 Xc03 Group_01.1 Ab03 Group_02.1 Ac02 Group_02.1 Ab05 Group_02.1 Bd03... (6 Replies)
Discussion started by: cowa
6 Replies