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 |
|
mike009
Starting Member
15 Posts |
 Posted - 2006-03-19 : 00:29:23
|
| heycan you please explain to me the following <"Because the database also stores all the data of the database itself, each database has a number of system tables. Each new database is created following the Model database model. The Master database keeps track of information about the other databases. In the Master database you will find views with names starting with INFORMATIOM_SCHEMA. Use the system tables to create a new view that will display the column names and the associated data type for each table. (s) Show every table in your scheme. ">can you give me an example?and what columns i need to create?how can i create view?and under what topic i can find this in book online?thx |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-03-19 : 01:12:36
|
| Homework emergency?CODO ERGO SUM |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-03-19 : 02:19:03
|
| "can you give me an example?"To do what?"and what columns i need to create?"That'll need a definition of the problem too ..."how can i create view?"What database management tools do you have available?"and under what topic i can find this in book online?""this"? There are several questions, you won't find them under one heading in BoL - or perhaps you were meaning to refer to a specific problem?Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-20 : 01:11:33
|
| Look for INFORMATIOM_SCHEMA in SQL server help file.MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
heeeeeeeeeeeeeeeeeeeeelp