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 Serveroraclemysqltableobject
Directory (?) [+]
When developing a project, there is a feature that needs to see what tables are in the database, and what fields are available for each table, viewed online, and now shared with you.
Oracle:
Query data table (Tables) Name:
Select table_name, Tablespace_name
From Dba_tables
where tablespace_name = ' USERS ';
Field (Columns) name in Query data table (Tables):
Sql1:select column_name from All_tab_columns where table_name= ' table1 ';
Sql2:select column_name from User_tab_columns where table_name= ' table1 ';
Query Database (Databases) name
SQL Server:
Query Database (Databases) name:
SELECT name from master.dbo.sysdatabases WHERE status <> 512
Query data table (Tables) Name:
SELECT name from dbo.sysobjects WHERE objectproperty (id,n ' isusertable ') = 1 and name <> ' dtproperties '
Query the data table (Tables) name with schema:
SELECT b.name + '. ' + a.name as name from sysobjects a INNER joins Sys.schemas B on a.uid=b.schema_id WHERE objectproperty ( Id,n ' isusertable ') = 1 and a.name <> ' dtproperties '
Field (Columns) name in Query data table (Tables):
SELECT * from Dbo.syscolumns WHERE id=object_id (N ' [production].[ Product] ') ORDER by colid
Or
Select name from syscolumns Where id=object_id (' Tname ')
Mysql:
Query Database (Databases) name:
Show DATABASES/* This can see all the database names */
Query data table (Tables) Name:
Show TABLES/* can view all tables in the current database */
Field (Columns) name in Query data table (Tables):
Show columns form table name from database name
Or:
Show columns from database name. Table name
Database name, data table name, field name in MySQL
