query to list all tables in oracle database

Tags: null SQL structure des ber rod comma connect appIf the Oracle server is loaded with multiple DB instances, enter the username/password @ database name at the user name. If the database server is not on this computer, you also need to add the address of the database server: username/password @ip address/

Label:can be applied to 2 different scenarios: 1. Clear all tables of data, after the data is emptied, it is best to be able to make the table identity column starting from 1 to count, so to reset the identity column's current value. 2. With replication, after the subscription synchronization data, the Subscriber data does not automatically grow, such as the self-increment ID of the 9527, but if the middle

Here is mainly about the database connection in PHP and database selection and display the current database all tables three practical functions, there is a need for friends to see. Here is the main talk about the database tutoria

This article mainly introduces how php batch deletes all tables prefixed with prefix _ in the database. For more information, see the following script to delete tables prefixed with "prefix: The code is as follows: // Set the database connection information.

Copy Code code as follows: CREATE TABLE #tmptb (tbname sysname,tbrows int , tbreserved varchar (+), Tbdata varchar (10) , Tbindexsize varchar (a), tbunused varchar (10)) INSERT into #tmptb exec sp_msforeachtable ' exec sp_spaceused '? ' SELECT * FROM #tmptb--Lists all tables SELECT tbrows, tbname from #tmptb WHERE tbrows=0-List of

Except the records of all tables in the specified database, an empty database is required. The method is as follows: I:Comparison between Delete and truncate table in SQL DeleteApplies to the deletion of a limited range, for example: delete titlesWhere type = "business"Because the delete operation writes trans

, name as Db_name from master. sysdatabases where Sid 4: Querying a table for fields and data typesSelect Column_name,data_type from Information_schema.columnsWHERE table_name = ' table name '[n]. [Title]:Select * from TableName Order by CustomerName[n]. [Title]:8. How to modify the name of the database:Sp_renamedb ' Old_name ', ' new_name '9. Copy only one table structure and not copy dataSelect top 0 * into [T1] from [T2]10. Connecting to a remote databaseSELECT * from OpenDataSource (' SQLOLE

Tname, CNAME from teacher join course on Teacher.tno=course.tno where tsex= ' man ' 42. Check the SNO, CNO and degree columns of the students with the highest score. Select*from score where degree in (select MAX (degree) from score) 43, inquiries and "Li June" with the gender of all students sname. Select sname from student where Ssex in (select Ssex from student where Sname= ' Li June ') 44, inquiries and "Li June" with the same sex and classmates s

Copy codeThe Code is as follows:Create table # tmptb (tbname sysname, tbrows int, TbREserved varchar (10), tbData varchar (10), TbIndexSize varchar (10), tbUnUsed varchar (10 ))Insert into # tmptb exec sp_MSForEachTable 'exec sp_spaceused ''? '''SELECT * from # tmptb -- list all tablesSELECT tbrows, tbname FROM # tmptb WHERE tbrows = 0 -- list

Program Idea: Use select name from sysobjects where xtype = 'U' to obtain all tables, and then open the table cyclically, according to rs_colums.fields (I ). name: field name. fieldtype (rs_colums.fields (I ). type) to obtain the field type, rs_colums.fields (I ). definedsize 'width Because rs_colums.fields (I). Type Returns numbers, a fieldtype function is written in the program to convert it to a Chin

"provider=microsoft.jet.oledb.4.0; User id=admin; Jet oledb:database password=yldb666;data source=@ "Test.mdb;" New OleDbConnection (connectionString); Conn. Open (); System.Data.DataTable schema = Conn. GetSchema (); This.dataGridView1.DataSource = schema;conn. Close (); Conn. Dispose (); U.sanwen.net/488516.htmlU.sanwen.net/488934.htmlU.sanwen.net/489154.htmlU.sanwen.net/489327.htmlU.sanwen.net/489637.htmlU.sanwen.net/490157.htmlU.sanwen.net/490589.htmlU.sanwen.net/490798.htmlU.sanwen.n

Application Scenario: if the field name is known, you can query all data tables in the database that contain the field name. Operation Method: Specify the field name and database table user, run the following query statement. The