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 |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2008-04-16 : 06:11:18
|
| Pls Tell Me How to get Name of Master and Transaction Table From The DataBaseYaman |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-16 : 06:20:38
|
From the SQL Server's point of view, every table is same. There is no category like Master and Transaction table from SQL Server's perspective. It is logical categorization. If you are following certain naming conventions for master and transaction tables, you can query INFORMATION_SCHEMA.TABLES view accordingly.For example, if you use "mst_" prefix to refer to master tables, you can get list of master tables by following query:Select Table_name from INFORMATION_SCHEMA.TABLES where table_name like 'mst_%' and Table_type = 'Base Table' Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2008-04-16 : 07:05:29
|
| Sorry Sir Query Cannot get the Right Result.Its only gives the base(Transaction Tables) tables result They did'nt get me Master table Information Yaman |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-16 : 07:14:37
|
| Did you followed my earlier post clearly? How do you define Master and Transaction tables in database? How can you differentiate between them?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
|
|
|
Get Master And Transaction Tables List