COMMENT on TABLE equivalent - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

COMMENT on TABLE equivalent

Author

Topic

Gerhard
Starting Member

2 Posts

Posted - 2004-10-19 : 14:06:28

What is the equivalent in MS SQL Server for the following Sybase SQL statement.

" COMMENT ON TABLE MYTABLE IS 'Hello' "

Here is the Sybase help for it:
TableComment

Statement for adding a table comment. The table comment is a SQL statement which is not supported by all DBMS. If

TableComment

is empty, the Comment check box in the Tables and Views page of the Database Generation box is grayed and unavailable.

Used in generation and reverse engineering.
Example

In Sybase SQL Anywhere 5.5:

TableComment = comment on table %OWNERPREFIX%%TABLE% is '%COMMENT%'

The %TABLE% variable is the name of the table defined in the List of Tables, or in the table property sheet. The %COMMENT% variable is the comment defined in the Comment textbox of the table property sheet.

Thanks
Gerhard

Kristen
Test

22859 Posts

Posted - 2004-10-19 : 15:15:23

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37796

Kristen

Gerhard
Starting Member

2 Posts

Posted - 2004-10-19 : 16:05:46

Thanks Kristen. Yes it is kind of sluggish in SQL Server.
Gerhard

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources