What is the equivalent of ‘describe table’ in SQL Server?

by

You can use the sp_columns stored procedure:

exec sp_columns MyTable

More Related Contents:

  1. Calculate a Running Total in SQL Server
  2. How can I do an UPDATE statement with JOIN in SQL Server?
  3. Not equal != operator on NULL
  4. SET NOCOUNT ON usage
  5. How can I get column names from a table in SQL Server?
  6. How can I select the first day of a month in SQL?
  7. Subquery using Exists 1 or Exists *
  8. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  9. Is it possible to specify condition in Count()?
  10. Update records in table from CTE
  11. how can I Update top 100 records in sql server
  12. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  13. How can a LEFT OUTER JOIN return more records than exist in the left table?
  14. Count Number of Consecutive Occurrence of values in Table
  15. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  16. Pivot data in T-SQL
  17. Column name or number of supplied values does not match table definition
  18. Split one column value into multiple column values
  19. Get the records of last month in SQL server
  20. Merge overlapping date intervals
  21. I want to use CASE statement to update some records in sql server 2005
  22. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  23. alternatives to REPLACE on a text or ntext datatype
  24. SQL poor stored procedure execution plan performance – parameter sniffing
  25. How to return a incremental group number per group in SQL
  26. SQL Server SELECT INTO @variable?
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Select a column if other column is null
  29. Date serial in SQL?
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment