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)

Billboard image

Create up to 10 Postgres Databases on Neon's free plan.

If you're starting a new project, Neon has got your databases covered. No credit cards. No trials. No getting in your way.

Try Neon for Free →

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay