var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Is there a statement to view table description in MS SQL
In Oracle I could type "Desc <table name> " to get the table and column information. Is there a similar statement in SQL 2000 to view a table description?
right click the table and select "Design Table"
I am using Query Analyzer to execute the SQL statment. I can not find Design Table in Query Analyzer. Please provide me more info.
In query analyzer, you can use SP_COLUMNS [table name] to get a list of all the columns of a table, along with all the properties of those columns.
I would recommend using "results in grid" to see the results.
Or for far more details about your table, you could use SP_HELP [table name]. This would give you several results about the table.
But I believe SP_COLUMNS will answer your question.