<< SQL Server Hosting - HostForLIFE :: How To Insert A Default Value In SQL Statement? | SQL Server Hosting - HostForLIFE :: Retrieving Table And Function In A Procedure >>

SQL Server Hosting - HostForLIFE :: How To Determine Table Details?

January 6, 2022 05:56 by author

Peter

Sometimes, we may need to know the table's metadata like
    Column Name,
    Data Type
    Column Size
    Index
    Constraint
    ETC.

And to be honest there are various ways to determine this but in the tip, we are going to share 2 simple ways to determine the table's detail

1. SP_HELP
The syntax of sp_help is very simple as shown below
SP_HELP 'TABLENAME'
GO

For example, if I have a Users table in my database then I can write the SQL command like below and hit F5
SP_HELP 'Users'
GO

Now, the other way is very very simple. In this, you don't have to write SP_HELP

Just write the tableName in the Query window. Select the table Name and hit ALT + F1

This will show exact same result which you get from SP_HELP.

I hope this simple tip might help you.

Thanks