describe table in sybase

How to describe the basic information of a data table ?, Description Basic Information Recently, I have worked with a colleague to design database tables. After designing each table, we need to record the basic information of the table and send it to colleagues in the same project team for reference and review. At the

Tags: Table structure mysql5.7 basic statementsObjectiveNo 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 default values, and so on.

[SQL] View PlainCopy 1, quite with the MySQL show databases; [SQL] View PlainCopy Select Datname from pg_database; [SQL] View PlainCopy 2, equivalent to the MySQL show tables; [SQL] View PlainCopy SELECT table_name from information_schema.tables WHERE table_schema = ' public '; Public is the name of the default schema[SQL] View PlainCopy 3, quite with the MySQL describe table_name;

Q: How does SQL server access the table of the sybase database? A: The specific method is as follows: 1: Install the Sybase Client Version requirements: Sybase client 11.9.2 for NT 1.1: After the installation is complete, start running->Program-> Sybase-> dsedit

Tags: UI data encounters database excellent weight cas post--Li Wu:Heng Learn to think together, honouring teachers save Thanksgiving. Leaf See root three return to one, rivers the same oneness.Meekness Conscience Lord, willing to do without regrets to the most bitter. Reading exercises to keep the body and mind, sincere advice and the line and cherish. Data, data, Lingen on the data. You must be cautious about operating the database. Give the most bitter code here, and take a look at

Users table:Order Form:Now in the Orders table, the creator and the update person are the primary key userid that corresponds to the users table, and when you query the order, you want to display the user name1. First give your usual wordingSelect O.orderid,IsNull ((select top 1 UserName from Users where userid=o.createpeople), Createpeople,--CreatorIsNull ((select top 1 UserName from Users where userid=o.u

; new linked server 3.1: In the regular label column Name Sybase, Server type Choose another data source, select in the name of the provider Microsoft OLE DB Provider for ODBC Data source: Fill in the DSN name 1.70 3.2: Security column Local Login Fill SA Remote users and remote passwords fill in Sybase username and password 3.3: Use this security context to establish a connection R

Because the database SQL statement in the major products with "dialect", that is, SQL Server Sybase are using T-SQL, MySQL is using standard SQL, Oracle has its own PL/SQL. Due to the differences in dialects, many SQL statements are difficult to transplant, and they are embarrassing in heterogeneous databases. Of course, DBA is nothing more than checking the syntax. But it is inconvenient. Here we will share with you the syntax analysis in the databas

Label:Company leaders want me to lead a file to the Sybase IQ database in a table, the load table statement is as follows:Load table Kyfx_ci_loc (City_name ', ', county_id ci_name ', ', ci_section ', ', ci_id ', ', Ci_longtitude_gps ', ', Ci_latitu De_gps ', ', Ci_longtitude_baidu ', ', Ci_latitude_baidu 0x0a) using fi

During this period, we studied the Sybase MDA monitoring table. During installation, the system always prompts that the loopback service connection is incorrect! Later I found that the loopback service was not provided in the dsedit tool. After creating the loopback interface, you must execute the statement in iSQL. First, set the CIS parameter to 1, indicating Sp_configure ' Enable CIS ' ,

Label:How to export Sybase database table records1 Execute the Start Sybase database commandCode:Dbeng7 GKDB2 Executing the Connect Sybase database commandCode:Dbisql-c "uid=dba111;pwd=222sql;eng=gk333db"-Q oilvouch.sql3 Execute SQL script file Oilvouch.sql export file Oilvouch.txtCodeSelect Top Ten * from Oilvouch;Out

Tags: Sybase SQL anywhere table information SQLIn Sybase central tools, we can often see the following pages:650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M02/89/67/wKiom1gRyE_zM-JyAABH3iPUDEM213.png "title=" Sybasecentral001.png "style=" border:1px solid #000000; "alt=" Wkiom1grye_zm-jyaabh3ipudem213.png "/>There was a client who had to export such a

Tags: roc share ACL isnull where SQL _id Simple Object 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 result. sp_help table