Hi,
How do I list Indexes, Primary Keys and Unique Constrains? I have tried to use the following statement:
SELECT * from SysIndexes where Id = object_id('CONTACTTYPE')
This gives me al...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20883559.html
I have been looking around on our system.
The update statistics are turned off on our backup maintenance plans.
So i been looking at sysindexes
I have some with indid 255 and some are 10, 11...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21847084.html
Hi I urgently need to write a query to return evrey object id and index id for each user defined table in the database. As I want to pass the rows to DBCC INDEXDEFRAG Via a loop. I also want to ex...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22012226.html
Is there a "nice" way of removing All Indexes on a Database ???
I imagine that the "not nice" way is to delete from the sysindexes table.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20639516.html
Hello All,
How do I find out wether an index is unique in my sql code? Also, how can I get the names of the columns covered by an index (composite or non-composite) in plain text.
I made a f...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20782596.html
Hi experts,
How can I , using sysindexes and the like, determine if an index is unique or not? I've looked at sysindexes and it doesnt tell me. I 've also examined the information_schema views...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20807116.html
Dear Experts,
I have found a query which returns all the Primary Keys and Indexes for a db. Is there a way I can unambiguously distinguish which is a Primary Key and which is an Index? (I know...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21787481.html
I have a few indexes from an inherited database that have the values in the sysindexes table of impid = -1 and indid = 255. The names of the indexes are not in the table itself. Were these indexe...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22046516.html
I have a table with an index whose name is _WA_Sys_MVndNbr_12A9974E. When I try to drop the index, I get the message that the index does not exist in system catalog. However, the index does exist i...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10305585.html
I would like to know how to use the sysIndex table to determine what are my primary keys, my indexes, and my clustered indexes.
When I run this query,
select convert(char(30),t.name),
in...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20106191.html
