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 name in the SQL Server library:
While not Rs. eof
Response.Write ("Database name:" & RS (0) & "<br>")
Response.Write ("Owner:" & Amp RS (1) & "<br/>")
Response.Write ("Table name:" & RS (2) & "<br/>")
Resp Onse. Write ("Table type:" & RS (3) & "<br/>")
So that we know the table name, let's take a look at how to manipulate the table's fields.
Suppose that there are tables in the database: [Things], the fields in the table: Id,thingsname,thingstype
Get all the field names for the table:
Set rs=server.createobject ("ADODB. Recordset ")
sql=" SELECT * from [things] where 1<>1 "
Rs.Open sql,conn,1,1 & nbsp
for I=0 to (j-1)
Response.Write ("First" & i+1 & "field Name:" & Rs. Fields (i). Name & "<br/><br/>")
OK, now we know how to get the name of the field.
If you want to do something about the value of the field you get, this is OK:
For example, if we want to delete the field thingstype in table [things], we can
Sql= ALTER TABLE [things] DROP COLUMN thingstype "
Another example we want to add a field th Ingscolor, its type is varchar, length is 20, and the default value is red, as follows:
Sql= "ALTER TABLE [things] ADD Thingscolor VARCHAR DEFAULT ' Red '
The basic operation of the above fields is implemented in SQL language, in ASP, With the SQL language, we can complete the
More database operations with sufficient permissions, such as create tables, delete tables with drop, and so on.