Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Darts75
Starting Member
27 Posts |
 Posted - 2014-03-15 : 06:23:40
|
| Hi Everyone,I am more familiar with writing SQL for Oracle than MS SQL Server. Within Oracle there is a simple command, 'Describe', which actually shows the data types, and whether or not an attribute accepts NULLS. MS SQL Server does appear to support such a command, however I am looking for a way to describe the attributes of tables nonetheless.If anybody can share some wisdom in this area it will be greatly appreciated.Kind Regards,David |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-03-15 : 06:49:24
|
[code]exec sp_help yourtablename[/code]
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
Darts75
Starting Member
27 Posts |
Posted - 2014-03-16 : 19:16:10
|
| Hello khtan,Thank you very much for your response, this is exactly what I needed.Kind Regards,Davo |
|
|
|
Monib
Starting Member
11 Posts |
Posted - 2014-03-24 : 06:34:35
|
| You can also do this, Just place a cursor on table, it will show a box below your cursor with written '(DBO.TableNameTABLE)'. Just click on it and it will show all the columns of the tables. |
|
|
|
Darts75
Starting Member
27 Posts |
Posted - 2014-04-30 : 01:22:25
|
Hi Everyone,I have noticed that when using the * (wildcard) along with a table name it is possible to hover ones mouse over the * and see a list of important attributes (columns) displayed along with their key characteristics. I hope that this pointer helps other users of Microsoft SQL Management Studio 2012.Kind Regards,Davo |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2014-04-30 : 11:50:55
|
| Maybe not what you are looking for, but there is also the Sql Server Data Tools (SSDT) that you can use to make database projects (as well as other BI projects). That way you can store your database schema (and other things) in source control, etc..http://msdn.microsoft.com/en-us/data/tools.aspx |
|
|
|
Darts75
Starting Member
27 Posts |
Posted - 2014-04-30 : 22:54:09
|
| Thanks for the insight Lamprey. I have also since learned that it is possible to highlight a table and then press ALT + F1 to see the table schema for that table. |
|
|
|
|
|
|
|
|
How to describe a tables schema