i want table name basis on column name.
Answers were Sorted based on User's Feedback
Answer / bobby
select * from information_schema.columns where
column_name='orderid'
The above query is used to find all the tables and views in
the Database which contain ‘orderId’ as column name.
But to find only the tables in the Database which
contain ‘orderId’ as column name, use the below query.
select col.table_name from information_schema.columns Col
join information_schema.tables Tab
on col.table_name=tab.table_name and
col.column_name='orderId'and tab.table_type='Base Table'
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / saravanan p
Please find the below query in which, the tables are
selected depends the column name empNo.
select table_name from information_schema.columns where
column_name='empNo'
Is This Answer Correct ? | 5 Yes | 1 No |
Answer / debasis
yes . it's possible
create table emp10(emp10 varchar(20))
Is This Answer Correct ? | 5 Yes | 3 No |
Answer / gowthami radhakrishnan
yes.we can have a column name in the table name.
create table order
(
order varchar(10),
number int
)
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / guruswamy
no,columnname and tablename not same to assign
Is This Answer Correct ? | 0 Yes | 6 No |
Tell me what is sql profiler?
What stored by the model?
You want to implement the one-to-one relationship while designing tables. How would you do it?
optimization techinques
Explain tablesample?
What is snapshot replication?
How we create SQL Server 2005 Reporting Services ? Give me Sample
How to find out name of all employees who has salary less than 200 Rs.?
how to determine the service pack currently installed on sql server? : Sql server database administration
What's new in sql management studio for sql server? : sql server management studio
When we should use and scope of @@identity?
WHAT IS UNIQUE IDENTIFIER DATA TYPE?