lengths, when complement is played; Range: -128~127 or 0~255
Smallint[length]
2 bytes
Length is the display of lengths, when the complement is played; see http://blog.csdn.net/libo222/article/details/51508379
Mediumint[length]
3 bytes
Length is the display of lengths, when the complement plays a role;
Int[length]
4 bytes
Length is the display of lengths, when the complement plays a role;
Bigint[length]
8
to high precision
BYTE, short, int, long, float, double, char
Note: Two char operations, automatically converted to int, when char and other types of operations, will be automatically converted to int type, and then do other types of automatic conversion
Base type conversions to class type
Forward conversion: To create a new class-type variable by using the class wrapper
Integer a= new Integer (2);
R
The CLR requires that each type is eventually derived from the object type, as follows:
Class Typer {} = = = Class Typer:object {}
The top is exactly the same.
All types are ultimately derived from object, and each type has a set of most basic methods:
Equals: Returns True if two objects are equal
GetHashCode: Returns a hash code for the object value
ToString: The full name of the default return type,
--oracle See all of the user's table names, table comments, field names, field comments, empty, field type SELECT DISTINCT table_column.*, table_nallable. Data_type, table_nallable. NULLABLE from (SELECT DISTINCT Utc.table_name table_name, utc.comments table_comments, Ucc.column_name column_name, ucc.comments column_comments from User_tab _comments UTC, User_col_comments UCC where utc.table_name = Ucc.table_name and utc.table_na
"None" type
Tea
Coca - cola
Disc type
Tea
Coca - cola
Circle type
Tea
Coca - cola
Square type
Tea
Coca - cola
Decimal type
Tea
Coca - cola
Decimal-leading-zero type
Tea
Coca - cola
Lower-roman type
Tea
Coca - cola
Upper-roman type
Tea
Coca - cola
Lower-alpha type
Tea
Coca - cola
Upper-alpha t
Tags: color objects type select Val Table name Export Data desc ObjectSELECT(case if A.colorder=1 then d.name Else ' end) Table name,A.colorder Field Ordinal,A.name Field Name,B.name field type,b.length field Length,G.[value] As Field descriptionFrom syscolumns a LEFT join systypes bOn A.xtype=b.xusertypeINNER JOIN sysobjects DOn a.id=d.id and d.xtype= ' U ' and d.nameLeft Join Sys.extended_properties GOn a.id=g.major_id and a.colid = g.minor_id--where D.[name] --where D.[name] = ' cityhot '-the
Label: Reprint Original AddressHttp://www.cnblogs.com/Fooo/archive/2009/08/27/1554769.htmlSELECT (case if A.colorder=1 then d.name Else ' end) Table name, A.colorder field ordinal, a.name field name, when Colum Nproperty (a.id,a.name, ' isidentity ') =1 then ' √ ' Else ' "End", (case when (SELECT count (*) from SYSO
Bjects WHERE (name in (SELECT name from sysindexes WHERE (id = a.id) and (Indid in (SELECT indid F ROM Sysindexkeys WHERE (id = a.id) and (Colid in (S
Get table names and comments:Select Relname as Tabname,cast (obj_description (Relfilenode, ' pg_class ') as varchar) as comment from Pg_class Cwhere relkind = ' R ' and Relname not-like ' pg_% ' and relname not-like ' sql_% ' ORDER by RelnameFilter out the Sub-table:Conditional and relchecks=0 can beGets the field name, type, comment, whether it is empty:SELECT col_description (A.attrelid,a.attnum) as Comment,format_type (A.atttypid,a.atttypmod) as type,a.attname as name, A.attnotnull as Notnull
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:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.