all shapes names

--oracle See all the user's table names, table gaze, field name, field gaze, is empty, field type SELECT DISTINCT table_column.*, table_nallable. Data_type, table_nallable. NULLABLE from (SELECT DISTINCT Utc.table_name table_name, utc.comments table_comments, Ucc.column_name column_name, ucc.comments column_comments from User_tab _comments UTC, User_col_comments UCC where utc.table_na

Get table names and comments:Select Relname as Tabname,cast (obj_description (Relfilenode, ' pg_class ') as varchar) as comment from Pg_class Cwhere relkind = ' R ' and Relname not-like ' pg_% ' and relname not-like ' sql_% ' ORDER by RelnameFilter out the Sub-table:Conditional and relchecks=0 can beGets the field name, type, comment, whether it is empty:SELECT col_description (A.attrelid,a.attnum) as Comment,format_type (A.atttypid,a.atttypmod) as ty

Label:SQL gets all database names, table names, stored procedures, and parameter lists1. Get all user names:SELECT name from Sysusers where status= ' 2 ' and islogin= ' 1 'islogin= ' 1 ' means accountIslogin= ' 0 ' indicates a roleStatus= ' 2 ' represents a user accountStatus= ' 0 ' indicates a system account2. Get

Oracle | sqlserver | names of all tables in access. Field Names * fromuser_tableswheretable_name: SELECT * FROMUSER_TABLES; other users: SELECT * FROMALL_TABLESWHEREOWNERUSER_NAME nbsp; Oracle | SQL server | names of all tables in access, Field

Java -- mysql -- get all table names and table field names ., Mysqltable Obtain the names of all tables in the database: (Reference: http://stackoverflow.com/questions/2780284/how-to-get-all-table-

Java Algorithm interview questions: Read all names from text files similar to the following, print duplicate names and repeated times, and sort by repeated times; read docx and read doc. Use the poi jar package to provide download, Read all names from text files similar to t

Queries all the table names and field names in the database. SQLView All table names:1. Select name from sysobjectsWhere type = 'U' 2. Select * From information_schema.tables Query the names of

Oracle|sql server|access Database Tutorial All table names, field names SELECT * FROM user_tables WHERE table_name = ' username ' Use the following statement if you are logged on with this user:SELECT *From User_tables;If you are using another user:SELECT * from All_tables WHERE owner= ' user_name 'First, the first sentence: is the query of the user under

Tags: style blog http color java io strong div htmlGet all table names for database:(Reference: Http://stackoverflow.com/questions/2780284/how-to-get-all-table-names-from-a-database)DatabaseMetaData MD == md.gettables (nullnullnull); while (Rs.next ()) { System.out.println (rs.getstring (3));}principle: Column 3 is t

--Get Stored Procedure creation statement Select O.xtype,o.name,cm.text from syscomments cm inner join sysobjects o on o.id=cm.id where xtype = ' P ' order By o.xtype,o.name,cm.text--get view path creation statement Select O.xtype,o.name,cm.text from syscomments cm inner join sysobjects o on o.id=cm . ID where xtype = ' V ' ORDER by o.xtype,o.name,cm.text--queries all table names, field

--get the stored procedure creation statementSelecto.xtype,o.name,cm.text fromsyscomments cmInner Joinsysobjects o onO.id=cm.idwhereXtype='P'Order byo.xtype,o.name,cm.text --Get view path creation statementSelecto.xtype,o.name,cm.text fromsyscomments cmInner Joinsysobjects o onO.id=cm.idwhereXtype='v'Order byo.xtype,o.name,cm.text --query all table names, field