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
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
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:
and provide relevant evidence. A staff member will contact you within 5 working days.