how to describe table in sql

Describe ()Function: Return the specified information about the structure of the data window control, including the datawindow object and data window.The attribute value of other objects in the object. Each column in the data window, each header,

The source of this article: http://www.cnblogs.com/wy123/p/6704619.htmlIssue backgroundIn a write SQL Server stored procedure, if a temporary table is defined in the stored procedure,Some people are used to explicitly delete a temporary table

This article uses six points to describe SQL lock usage overview. If you need to know about mssql locks, you can refer to this article for details. This article uses six points to describe SQL lock usage overview. If you need to know about mssql

The with as phrase, also called the subquery section (subquery factoring), allows you to do many things, define a SQL fragment that will be used by the entire SQL statement A. Meaning of with ASthe with as phrase, also called the subquery section

SQL Study Notes (14) ------------ data table, SQL statement for creating a data table Operations on Data TablesBasic Database OperationsWith MySQL, you can choose between the three basic database table formats (version 3.23. When creating a table,

Briefly describe the query and Solution to deadlocks in Oracle databases, and briefly describe oracle Deadlock PrincipleIf you update or delete a column in a table in the database, this statement is not mentioned after the execution.The statement

Describe the principles and three implementation methods of distributed locks in detail, and describe the principles of locks. Currently, almost all large websites and applications are deployed in a distributed manner. Data Consistency in

A The meaning of with ASThe with as phrase, also called the subquery section (subquery factoring), lets you do a lot of things by defining an SQL fragment that will be used by the entire SQL statement. Sometimes it is to make the SQL statement more

0. ReferencesTable Scan, Index Scan, index SeekSQL Server–index Seek vs. Index Scan–diffefence and Usage–a simple NoteHow Oracle tables are accessedDifference between index seek and index scan and where applicableHow to access tables in 1.oracleIn

ObjectiveNo more nonsense, just go straight on.1. View the table structure Basic statement describeThe DESCRIBE/DESC statement can view table field information, including: Lot Name, field data type, whether it is a primary key, whether there are