desc database

after the database design is complete, it is often necessary to keep a desc description of all tables in the database in a wiki or other document, in particular the meaning and purpose of each field. It is not advisable to manually generate the

Domino and relational database interaction is a common aspect of day-to-day project development that every Domino developer has written, and this article makes a simple summary of this.One, the tool article1. Use Lei (Lotus Enterprise Integrator)Lei'

id,mol,ip,port,name,t.desc,maxac,maxi,mini,maxw,status Select from t_sys_thorfd t order by status Desc A simple query statement has been an error in the location of Desc, at first thought it wasORDER BY Status Desc error, check

Exception: Type mismatch05-06 08:12:38.151:e/androidruntime (14904): Java.lang. numberformatexception:invalid int: "18600000099"05-06 08:12:38.151:e/androidruntime (14904): at com.itheima.mobilesafe74.activity.blacknumberactivity$ Myadapter.getview (

Source: http://zhumeng8337797.blog.163.com/blog/static/100768914201179112318218/ 1. DESC tablename;For example, mysql> DESC jos_modules;+ ------------------ + --------------------- + ------ + ----- + --------------------- + ---------------- +| FIELD

The boss gave a task, search the information, think it is better to summarize. What if I use it later? Around two topics: one is the ability to index on a view, and the other is whether the DESC keyword can be used when creating an index.One, can I

In MySQL, if you want to see the definition of a table, you have the following options1. Show CREATE TABLE statement:Show CREATE TABLE table_name;2. DESC TABLE_NAME Statement:CREATE TABLE person ( ID int. NOT NULL auto_increment primary key,

During the test today, I want to query the tablespace information corresponding to the data file. In the desc dba_Data_files view, I found that this object does not exist. At that time, I thought it was normal that my DB could not be queried under

1 How to execute a SQL script file, this script file writes a series of sets of SQL statements, such as Sql.sql placed under D:\MyEclipse 8.6\workspaces\oasystem\webroot\sql.sql"CD D:\MyEclipse 8.6\workspaces\oasystem\webroot\>>sqlplus>>@ Sql.sql;2

After many times I have verified. Finally, we found a way to query the database structure in Sybase.Before that, I was very puzzled about how this Sybase database is not as easy as Oracle and MySQL.DESC table name;After the online query, get a