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 |
|
Charles Egan
Starting Member
21 Posts |
 Posted - 2013-06-04 : 18:28:13
|
| As a newbie, I have a question which I hope isn’t too stupid:In SSMS, I know I can view information about a database viaObject Explorer | Database Engine instance | database (right-click) | Properties But isn't there any way to view individual records in the database? Otherwise, how do I even know what data fields are in the individual records? Without knowing even that much, how can I even practice making queries? |
|
|
Charles Egan
Starting Member
21 Posts |
Posted - 2013-06-04 : 18:53:52
|
| I'm sorry; I think that this thread should have been posted to the "New to SQL Server Programming" forum. If the moderators decide to move it there, I'll understand. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-05 : 00:20:29
|
| you need to look at INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.COLUMNS views for thatINFORMATION_SCHEMA.TABLES will give details of tables in database and INFORMATION_SCHEMA.COLUMNS will have details of columns for each of the tables.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-05 : 08:25:55
|
| When you do the "Object Explorer | Database Engine instance | database (right-click) | Properties ", you are really looking at the tip of the iceberg. A database server is organized in a hierarchy, with the root of the tree being Server. A server can have many Databases, and each database can have many Objects (such as Tables, views, etc.), and each table can have many columns (so called fields) and rows and so on.The object explorer allows you to navigate down the tree by expanding the nodes. When you install a new server, there are no user databases in there, only system databases (which you don't want to play with until you are very familiar and sure of what you are doing).You can create new databases by right clicking on the databases node in the object explorer. Once you have created a new database, you can create tables in it by right clicking on the tables node in the object explorer under that datbase.Once you have created a table, you can edit and insert data into it.All of what I described above is the graphical way of doing things. But most business is carried out via scripts (for example, for createing a table you would use a CREATE TABLE command).Google and explore with the above picture in mind and you will find lot of useful and helpful info. |
|
|
|
|
|
|
|
|
how to know record structure