Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
view tables,sp & views from a query
- Thread starter nirmalsp
- Start date
Tables:
select table_name from information_schema.tables
where table_type = 'BASE TABLE'
Views:
select table_name from information_schema.tables
where table_type = 'VIEW'
Stored Procedures:
select name from sysobjects where xtype = 'P'
Rick.
select table_name from information_schema.tables
where table_type = 'BASE TABLE'
Views:
select table_name from information_schema.tables
where table_type = 'VIEW'
Stored Procedures:
select name from sysobjects where xtype = 'P'
Rick.
- Status
Similar threads
