DEV Community

StuartCreed
StuartCreed

Posted on

mssql cheatsheet - in progress

To find the structural information about a table in mssql:

sp_help table_name
Enter fullscreen mode Exit fullscreen mode

Use the top helper like select top 10 * from table_name to limit the number of results from a select wildcard

Top comments (0)