Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

Questions tagged [comments]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-2 votes
0 answers
32 views

Azure Data Studio Comment Blocks

I have used nested comment blocks in the past while writing queries using SSMS and never thought about whether or not it was alright. I was giving Azure Data Studio a try and noted that it doesn't ...
user avatar
0 votes
1 answer
23 views

Can show the comments writing in the create table command?

We can write comment to create a table: create database `mytest`; use `mytest`; create table `mytest` ( /* mytest mytest */ `code` varchar(15) NOT NULL, `type` varchar(20) NOT NULL ); How can ...
user avatar
  • 126
1 vote
1 answer
36 views

Is the "comments" field in pgAdmin 4 a pgAdmin thing, or is it a PostgreSQL feature?

If I right-click a table (or any object) in pgAdmin 4 and select "Properties", it brings up a GUI window which allows me to change the name of the table and many other things. One of the ...
user avatar
0 votes
2 answers
809 views

SQL SERVER: How to get the stored procedure text EXCLUDING comments?

I need to find all the stored procs that use Transactions, as I want to enable transaction abort to those procedures. However, --I didn't do this; it's inherited-- many of the stored procedures ...
user avatar
3 votes
1 answer
1k views

What is the maximum length of a comment in PostgreSQL?

PostgreSQL has a special piece of a functionality called COMMENT which attaches metadata to an identifier or any type (schema, table, column, function, type, domain, etc). It looks like this, COMMENT ...
user avatar
  • 55.8k
5 votes
2 answers
281 views

SQL Comments disappear with psql and `\e`

Is there anyway at all, ever to change the behavior of comments in psql. Take the query below. Execute it. CREATE TABLE foo AS SELECT x AS id, -- x AS id2, x AS id3 FROM generate_series(1,...
user avatar
  • 55.8k
3 votes
1 answer
575 views

Can comments in stored procedures cause problems

We're running a webserver that calls stored procedures to compute complex queries. Using sp_who2, we've discovered a peculiar issue where an abnormal number of processes would be stuck on SELECT state ...
user avatar
  • 275
39 votes
1 answer
33k views

Changing mysql table comment

I know that mysql table comment can be defined at the creation with: create table (...)comment='table_comment'; And you can display comments by: show table status where name='table_name'; How do ...
user avatar
  • 493
1 vote
1 answer
5k views

Line Comment in MongoDB config file

How to mark a line comment in mongodb configuration file? cpu=true #temporary for dev env Is this the right way? There is no clue about it in their website page about setting the configuration ...
user avatar
  • 113
8 votes
1 answer
9k views

Comments in EXPDB parameter file

Is there a way to put comments in a data pump export parameter file?
user avatar
  • 23.5k
2 votes
2 answers
2k views

How can can I get object definitions stripped of all comments?

When I want to know if a stored procedure or views references a given name (table, view or column), I need a version of the object definition stripped of all comments. Is this possible by a SQL ...
user avatar
  • 11.8k