CODEWITHSUNDEEP
sqlsql-server
Trish Samson
Trish Samson

Reputation: 41

SQL Server Management Studio - Determine data types

I just created a table in SQL Server Management Studio and now I forget what datatypes I assigned to some of the fields. How do I access that information?

Upvotes: 1

Views: 17436

Answers (4)

Jonathan Porter
Jonathan Porter

Reputation: 1556

If you select a table name in the query window of Sql Server Management Studio and press ALT + F1 it will display the details of that table.

In the background shortcut key will execute sp_help on your behalf, so in this example it executes: sp_help users, which is much quicker than typing it.

enter image description here

Source Here

Upvotes: 6

oɔɯǝɹ
oɔɯǝɹ

Reputation: 7625

Right click on the table, choose 'Design table'.

Upvotes: 3

serhat_pehlivanoglu
serhat_pehlivanoglu

Reputation: 982

sp_help tablename . Gives you information about your table including fields and datatypes

Upvotes: 2

Derek
Derek

Reputation: 23228

select * from information_schema.columns where table_name = <yourtable>

Upvotes: 1

Related Questions