Discover what field name in database, include the articles, news, trends, analysis and practical advice about what field name in database on alibabacloud.com
SQL modifies the database name, table name, and field name
[Materials from the network]
Modify database name: alter database original database name modify name = new database name
ADD field: alter table Supplier ADD LoginPassword varchar (20) No
How to query the database name, data table name, field name in Oracle,sql server,mysqlCategory: Database2012-09-24 22:16 7034 people read reviews (0) favorite reports Database SQL ServeroraclemysqltableobjectDirectory (?) [+]When developing a
Recently, in the ASP forum to see a lot of netizens asked how to get the database table name, field name and how to delete the field, add the operation so write this article.
I am more familiar with SQL Server, so SQL Server is the column:
SET
All data in the database is stored in the table. Data tables include rows and columns. The column determines the data type in the table. The row contains the actual data.
For example, the table authors in the database pubs has nine fields. The
ASP gets the database table name, field name, and some operations on the fieldRecently, in the ASP forum to see a lot of netizens asked how to get the database table name, field name and how to delete the field, add the operation so write this
Code example for extracting information such as database table name and field name using SQL
This article describes how to use SQL statements to extract the instance code of table names and field names of all tables in the database. The test is
In mysql, we only need to use alter to modify the data table fields. Below I will introduce how to modify the table field name, field length, and field type in mysql, for more information, see.
Let's take a look at common methods.
The simple Syntax
ASP get database table name, field name
Take SQL Server as an example:
Copy Code code as follows:
SET conn=server.createobject ("ADODB. Connection ")
Conn.Open "SERVER=IP address; provider=sqloledb;database= library name; uid=
ASP get database table name, field name
Take SQL Server as an example:
SET conn=server.createobject ("ADODB. Connection ")Conn.Open "SERVER=IP address; provider=sqloledb;database= library name; uid= user name; pwd= password; "%>
Read the table
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.