CODEWITHSUNDEEP
sqlsql-server
Vinod Kumar
Vinod Kumar

Reputation: 408

Is it possible to add description for column while creating table in MSSQL QUERY

Is it possible to add description for column while creating table in MSSQL QUERY. I am in need to add description for columns in table while moving data to the table.

Upvotes: 0

Views: 1324

Answers (1)

Eric Brandt
Eric Brandt

Reputation: 8101

It's clunky in SQL Server. For some reason, they've never adopted the COMMENT syntax, and you can't add the comments directly in the CREATE TABLE statement.

After your CREATE statement, run the system stored procedure sp-addextendedproperty

There's an extended conversation on the topic under this question: SQL Comments on Create Table on SQL Server 2008

Upvotes: 3

Related Questions