Select from the system table: $ android-sdk-linux_86/platform-tools/adb shell ... Other useful commands: sqlite> .databases seq name file ...

Use show create table <tablename> : mysql> show create table my_test_table; +------... Select from information_schema.table_constraints and information_schema.key_column_usage mysql> select * from information_schema.table_cons...

Select from information_schema : mysql> select cc.character_set_name -> from... Other columns available from the information_schema tables: mysql> desc tables; +-----------------+--------... Note that show create table <table_name> also works.

Select from information_schema.tables : mysql> select table_collation from information_sch... Or, show create table mysql.host; CREATE TABLE `host` ( `Host` char(60) collate...

The tags <c:if> The <c:if> tag may be used with or without body content: <!-- Without body content, used to export vari... In my opinion, the version without body content is pretty much useless (the <c:set> tag is a lot more meaningful for this purpose). If body content exists, it is inserted into the page if the testCondition is true . Optional attributes var and scope may be specified. If var is specified, a variable whose name is the value of var is exported to the associated scope ( pageScope if no scope is specified). The type of the exported variable is Boolean and its value is the value of the testCondition . <c:choose>, <c:when>, <c:otherwise> These tags imitate the Java control structure if...else...

Use the \d command to show information about a table: postgres=# \d patchtype Table ...

ALTER TABLE PatchInfo ADD CONSTRAINT FileNameKey_U...

-- add a foreign key to abother table alter tab...

-- disable foreign key alter table my_table...

If you create a model like the following: from django.db import models class Person(m... Django creates the corresponding table like this: CREATE TABLE person ( "id" number(11,0) NOT... Since Oracle doesn't have IDENTITY or AUTO_INCREMENT column, how does Django create the primary key when you insert a new person? In fact, when you run python manage.py syncdb with an empty database, Django also creates a sequence and a trigger: create sequence person_sq; create or replace TR... However, if you have an existing Person table and are creating a Django model for it, the sequence and trigger won't be created when you syncdb . You have to manually create them in order for inserts to work.

This is the syntax to drop a foreign key: ALTER TABLE my_table DROP CONSTRAINT fk_my_fore...

This style sheet transforms the struts-config.xml into HTML for easy viewing in a browser. It uses the DHTML JavaScript tooltip from http://www.walterzorn.com/tooltip/tooltip_e.htm . <?xml version="1.0" encoding="UTF-8"?> <xsl...