Search
 
SCRIPT & CODE EXAMPLE
 

SQL

commentaire table oracle

COMMENT ON TABLE table_name IS 'A table comment';
COMMENT ON COLUMN table_name.MY_COLUMN IS 'A column comment';

SELECT * FROM ALL_TAB_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';
SELECT * FROM ALL_COL_COMMENTS WHERE TABLE_NAME = 'TABLE_NAME';
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql dump all databases 
Sql :: display all databases 
Sql :: how to get yesterday date in mysql 
Sql :: mysql get column names from table 
Sql :: sql now - 1 day 
Sql :: mysql grant all privileges to a user 
Sql :: sql server read uncommitted 
Sql :: sqlite alter table add column 
Sql :: check current sequence value postgres 
Sql :: sql query to get column data type in sql 
Sql :: mysql get first x characters 
Sql :: mysql add column if not exists 
Sql :: oracle rename table 
Sql :: python sqlite3 create table if not exists 
Sql :: find table for column name in sql 
Sql :: mysql command line connect 
Sql :: mysql allow remote connections 
Sql :: revoke a role from user microsoft sql server 
Sql :: how to change table name in sqlite 
Sql :: how to get last row of table in sql 
Sql :: Check Table Exists 
Sql :: postgres connection string 
Sql :: Sql query to force the database to be drop 
Sql :: how to add unique constraint in mysql table 
Sql :: sql server reset auto increment 
Sql :: mysql delete binlog 
Sql :: get the rows from two tables whose relation is in 3rd table 
Sql :: O SGBD MySQL utiliza um schema próprio para o armazenamento das tabelas que compõem o dicionário de dados. Marque a alternativa que indica o nome do s 
Sql :: mysql reset auto increment 
Sql :: list all tables and columns in postgresql 
ADD CONTENT
Topic
Content
Source link
Name
5+1 =