skip to main | skip to sidebar

Radhakrishnan's Tech - Tips page

This blog have the technical tips relates with various domain

Tuesday, 27 March 2007

Sql query to find table having indexes


echo "select tabname from systables where nindexes > 0 and owner ='svplus' " | dbaccess stratacom

Posted by வெங்காய வெடி at 11:51 pm
Labels: Informix

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Labels

  • Informix
  • solaris

My Photo

My Photo

Blog Archive

  • ▼  2007 (8)
    • ▼  March (8)
      • kill the sessions held locks on the dbspace
      • Sql query to find table having indexes
      • Data base size estimation for a table having 1 Cro...
      • To remove a file or Directory
      • An Inline Shell Script with a For Loop
      • File Permissions
      • Change User or Group Attributes to a File
      • My Tech Page

About Me

வெங்காய வெடி
View my complete profile