Thread: Command to describe a table in sql server. Autoplay When autoplay is enabled, a suggested video will automatically play next. Sign up using Email and Password. Forgot Password? SteveW SteveW 1 1 silver badge 4 4 bronze badges. Kubernetes for Beginners - Docker Introduction - Duration: Your table structure will be displayed completely. Igor Zaychik. Sign in.
Just in case you don't want to use stored proc, here's a simple query version.
Using exactly DESC OR DESCRIBE or equivalent command in SQL Server
an sql*plus DESC(RIBE) like select (displays the column comments, too) in t-sql. I've roughly translated that to the SQL Server equivalent for you - just make sure. for Description/ detailed information of Table in SQL Server while using the code it doesn't like columns that are not VARCHAR type. In Sql Server DESC is the short form of DESCending. EXEC sp_help 'mytable'; this can not be desc the table this only to show all DESC is not an SQL command, it's an SQL*Plus function - i.e., it won't work on other tools.
June 19, AM.
Describe table structure with MS SQL Server Electric Toolbox
Active 8 months ago. Some name 98k Followers.
Video: Desc table ms sql server Describe table structure in Sql Server
Thread: Command to describe a table in sql server.
But to describe a table or object MS SQL Server provides a very useful command or built-in stored procedure sp_help.
One can easily describe.
Sign up using Email and Password. Asked 11 years ago.
What is the equivalent of 'describe table' in SQL Server Stack Overflow
Thanks in advance. Related Add to Want to watch this again later?
Sexion jai pas les loves lyrics
|Email Required, but never shown.
Like this video? Pravin Pravin 3 3 silver badges 6 6 bronze badges. Copyright Quinstreet Inc. Linked NET Framework.
Microsoft SQL Server Index Defragmentation Best Practices. In Oracle we are using desc command to describe a table(to show the fields and its datatype). But in SQL Server, which command we can use.
You might paste security vulnerabilities, too. Hot Network Questions. Note that, if you have the table in a user-defined schema, you should exclude it from the query.
Please read the thread before posting. Active 6 days ago. Advertiser Disclosure. Hi, I have a sql which can help you