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 |
|
sandeep424
Starting Member
1 Post |
 Posted - 2012-06-28 : 23:46:33
|
| Hello GuysI need a favour. I wanted to know that when I create a table using SQL Server, does the table metadata like schemaname and catalogname is stored in memory or in hard-disc. I am trying to extract schemaname and catalogname when the database is down or correctly when I have no connection string. I know about sysindexes, systables etc, but i am not able to understand whether it stores the data which is useful to me like catalogname. and can someone post me sql query to extract the column names from sysindexes.Thank you in advance |
|
|
|
|
|
Get Table MetaData like catalogname, schemaname