Search
 
SCRIPT & CODE EXAMPLE
 

SQL

alter table add comment 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 :: postgresql generate uuid 
Sql :: mysql show databases 
Sql :: mariadb select multiple rows into one column 
Sql :: sql get missing id 
Sql :: this month mysql where 
Sql :: search stored procedures 
Sql :: create table in postgresql 
Sql :: mysql convert timestamp to date 
Sql :: mac xampp mysql not starting 
Sql :: sql query to get column names and data types in sql server 
Sql :: date today snowflake 
Sql :: STRING_AGG order by 
Sql :: sql add date hour 
Sql :: sql last row in table 
Sql :: postgres sequence name 
Sql :: created at and updated at in mysql 
Sql :: mysql get time from datetime 
Sql :: see all users mysql 
Sql :: rename table postgres 
Sql :: oracle current date without time 
Sql :: sql count duplicate rows 
Sql :: postgresql change column to not null 
Sql :: sql pick random row 
Sql :: mysql set field unique 
Sql :: reset auto increment sql server 
Sql :: t-sql find object by name 
Sql :: hexadec to sql REDSHIFT 
Sql :: oracle aleter trigger ora-01031 
Sql :: oracle source query 
Sql :: mysql full outer join java 
ADD CONTENT
Topic
Content
Source link
Name
9+7 =